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