CREATE DATABASE and USE database statement at the beginning of the script in the file of the Sample Database in order for SQL Script in the Sample Database to execute/run correctly If you discover any ambiguity between the written Metadata and the actual table definitions, the path that I recommend is to use the SHOW TABLES Statement and the DESCRIBE Table Statement to eliminate any ambiguity between the written Metadata and the actual Metadata. CustOrders.sql Aggregation Part of the Exercise . Select the maximum price of any orders in the items ordered table. Hint: Select the maximum price only. . Select the average price of all of the orders that were purchased in the month of Dec. . Return the total number of rows in the orders table? . For all of the tents that were ordered in the orders table, what is the price of the lowest tent? Hint: Your query should return the price only. Group By Exercises How many people are in each unique state on the customer table? Select the state and display the number of people in each state. Hint: count is used to counting rows in a column, sum works on numeric data only. . From the items_ordered table, select the item, maximum price, and minimum price for each specific item in the table. Hint: The items will need to be broken up into separate groups. . How many orders did each customer make? Use the items_ordered table. Select the customer identification, the number of orders they made, and the sum of their orders. Having Clause Exercise How many people are in each unique state in the customer table that has more than one person in the state? Select the state and display the number of how many people are in each if it's greater than 1. From the order table, select the item, maximum price, and minimum price for each specific item in the table. Only display the results if the maximum price for one of the items is greater than 190.00. How many orders did each customer make? Use the orders table. Select the customer identification number, the number of order