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 the manager _ id field of the employee reporting to that manager. In order to produce a list of which managers supervise which employees, the table may be joined to itself using these two attributes( employee _ id, manager _ id). This is known as a SELF-JOIN. Use a SELF-JOIN on the employees table to produce a result containing two