Provide a SQL statement that displays the ISBN, TITLE and PROFIT for all books where the COST is greater than or equal to $10.00 and less than or equal to $40.00. (The PROFIT is the difference between RETAIL and COST.) Include only those books that were published since January 1, 2001.

Problem #3

Provide a SQL statement that displays the TITLE and publisher NAME of each book in the “COMPUTER” CATEGORY.

Problem #4

Provide a SQL statement that displays the CUSTOMER# and LASTNAME for each customer along with the ORDER# of any order that the customer placed. The statement should include all customers including those that have not placed any orders.

Problem #5

Provide a SQL statement that displays the total QUANTITY of books ordered.

Problem #6

Provide a SQL statement that displays each SHIPSTATE along with the number of orders shipped to each state. Include only those states that more than 3 orders were shipped to.

Problem #7

Provide a SQL statement that displays the TITLE of all books that COST more than the average cost of all books.

Problem #8

Provide a SQL statement that displays the ORDER# for all orders that included the book titled “COOKING WITH MUSHROOMS”.

Problem #9

Provide a SQL statement that displays each book CATEGORY in the database. The category should only appear once in the output.

Problem #10

Provide a SQL statement that displays the current date in the format MM/DD/YY.