Write query "List the title and publication date for each book in the BOOKS table. Use the column heading "Publication Date" for the Pubdate field"； “Determine which categories are represented in the current book inventory. List each category only once”

Write query "Rerange the data in ascendimg order based on the cost of the book"

From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);

Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.

Display the total number of credits earned in each year using the tot credits (year, num credits) view.

In the BOOK_PRICING table, you should indicate that the Category field is not being utilized. Confirm that the column is no longer an option to choose.

Write the following as MySQL query: Find the employee ID, first and last name, and salary for each employee whose salary ismore than $20,000 or who works in the shipping department. Use the UNION set operator. List the country ID, country name, city, and state/province. Be sure all country names areincluded in the result, regardless of whether there is no matching city and state/province. You have to use an outer join.

Create a stored procedure using the companyname, most recent order date, and ship address for companies beginning with the letter A.

Please help: Using the following sql file, how would you find  List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number.     Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…

8) Create a query for displaying list of employees who joined in the second half of year ‘07’;