This assignment uses the database create_my_guitar_shop.sql. Write all queries and answer all questions using this database. Save and upload all of your scrips in Notepad and upload to Canvas. It is preferable save with a .sql file extension. 1. Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table 2. Write a SELECT statement that returns one row for each category that has products with these columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table Sort the result set so the category with the most products appears first. 3. Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address column from the Customers table The sum of the item price in the Order_Items table multiplied by the quantity This assignment uses the database create_my_guitar_shop.sql. Write all queries and answer all questions using this database. Save and upload all of your scrips in Notepad and upload to Canvas. It is preferable save with a .sql file extension. 1. Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table 2. Write a SELECT statement that returns one row for each category that has products with these columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table Sort the result set so the category with the most products appears first. 3. Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address column from the Customers table The sum of the item price in the Order_Items table multiplied by the quantity