Write a query to create a report that displays the count of the number of tables in the SQ library. Use DICTIONARY.tables as input.

From invoices table, write a query to retrieve everything (all columns), plus, add an additional column that retrieves difference in the number of days between the invoice due date and paymentdate, and name the column “Difference”. Note that the difference in days should be calculated bysubtracting “payment_date” from “invoice_due_date”.Hint1, refer to the following sample:... Invoice Due Date Payment Date Difference... 2018-05-08 2018-05-07 1... 2018-05-10 2018-05-14 -4... 2018-05-13 2018-05-09 4Hint 2: simple subtraction or DATEDIFF function. Both works.

Write a query to get the maximum and minimum salary from the senators table (in that order).

a. Write a query to get all unique first names that start with the letter W from the student table.  Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an T from the student table and sort them in descending order.

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

Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER