Write a query to display the book number, title, and year of publication for all books that contain the word “Database” in the title, regardless of how it is capitalized (Figure P7.80).

Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name

Employee table: (E_Id,E_name,dept_name,Salary) Write Update query Increase salary by 5000 if salary between 30000 to 35000 Increase salary by 7000 if salary between 35001 to 41000 Increase salary by 9000 if salary between 41001 to 46000

8) Display the firstname, lastname of the employees and the customerID that the employee served such that the employees are born after '1960-01-01'. Arrange the results by the last name. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY) NOTE: Please use only table joining to write the SQL quereys.