3 . Use the implicit join syntax ( the WHERE clause ) to display the last name , city , order date and ship date for all orders shipped in 2012 .
4 . Use any join syntax EXCEPT NATURAL JOIN to list the customer _ first _ name and customer _ last _ name concatenated with an intervening space as Customer , customer city and state formatted as a single column in the format of ― city , ST ‖ with a heading of Location , order _ id and order date for orders that have not shipped .
5 . List the customer name , order date , zipcode for any customer ( s ) placing an order for the item titled ‗ Etcetera ‖.
6 . Write a query to list the title and artist of ONLY the items that have been ordered . Only list each title once .
7 . Write a query to list the title and price of all items that have been ordered by customer Millerton .
8 . Write a query to list the last name and order id of customers that ordered any items by the artist Burt Ruggles ?
9 . Write a query to display a list of titles along with the artist name ., sorted by artist name .
10 . Write a query to display an invoice for order 693 including the title , quanty , price , and a calculated column to display the line item subtotal ( quantity times price ) with a heading of Subtotal .
11 . Display the order id , last name , title , and quantity for any items where customers have ordered 2 or more of a particular item in an order .
12 . The employees table contains a list of employees of a company . An employee may be managed by another employee . To denote an employee ‘ s manager , the employee _ id of the manager is entered into