Problem #2
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