USE classic models schema

1. Write a query that would list the customers name, city, state, order number and status where their order has not shipped. Use alias for table names.

2. Write a query that reports total payments and number of payments for each customer listed from the highest total payments to the lowest. Display the customerName and TotalPayments, number of payments columns. Use aliases.

3. Write a query that would sort products grouped by order dates for orders created/submitted in 2003. Display orderDate and productName. Use alias for table names. Hint: MySql has a YEAR() function