Write query "Display a list of all data contained in the BOOKS table"

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

Do fast please.

What are some common uses for the STRING_AGG function in SQL?

Problem 9 Write a query to count the number of invoices.

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…

3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.

Write a query in SQL code for: "List the book categories and the average book price of each category."  Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY

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

databse programming