Write a query that displays the book title, cost, and year of publication for every book in the system. Sort the results by book title.

Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.

Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.

You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause).  (you MAY use 1 or 2 statements)  Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear

Create a query to calculate Quantity_Sold * Sale_Price and compare the calculated value to Sale_Amt by calculating the difference to ensure it is zero

If a subquery is used in the FROM clause of a query, how are the subquery’s results referenced in other clauses of the query?

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

Write a query that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in CUSTOMER table, call this CUSTOMER_NAME), Phone number of ALL Customers (based on CUS_AREACODE and CUS_PHONE in CUSTOMER table, call this CUSTOMER_PHONE), for those haven’t flied before (based on the record in CHARTER table).

5. Which orders were placed on or before April 1, 2009? List each order number and orderdate. Write this query in two different ways.