Note: Use redcat schema. Note: If you get a message that the table or view does not exist or if a column does not exist, it just means that you need to use a different schema. Note: For most of these questions, change your schema to redcat$2.1.$ Write the SQL statement to answer this question: What is the average shipping cost on sales made in the month of June? Name $($alias$)$ the column $$Average Shipping Cost$.$ Also use the Round function to two decimal places for currency. I get $26\mathrm{.}28$ as my answer. $2.$ Write the SQL statement to answer this question: What is the total value of products purchased by customer $144?$ Name the column Total. $($Hint: use joins$).$ Value is calculated by the quantity $*$ listprice. I get $905\mathrm{.}94$ as my answer. $3.$ Write the SQL statement to answer this question: What is the largest dollar amount $($SalePrice times Quantity$)$ for a sale item that was ever made? Name it LargestItemSale. I get $360$ as my answer. $4.$ Write the SQL statement to answer this question: For each category and color, what is the maximum list price of men's shoes in that category and color? Sort by Category. Name the column $$Maximum Price$.$ Only show category, color and maximum price. HINT: Must use GROUP BY$.$ I get over $100$ rows of data. $5.$ Use a subquery to list the name and list price of products that were sold on a sale for which the shipping cost was over $$60.$ Use the PRODUCT table. I get $7$ rows returned. $6.$ Use a subquery to list the number of products made by manufacturers located in CA $($California$).$ Use the PRODUCT table. I get $630$ as the result of this query. $7.$ To create a view, you must change to your own user credentials. Write the SQL statement to create a view that lists the product name, color, and list price of men shoes sold in New Jersey $($NJ$).$ Use the PRODUCT and MANUFACTURER tables. $8.$ Using the view created in the previous question to write the SQL statement to display the average price of all black shoes. Note that the check must be case insensitive. Hint: I get an average price of $ $35\mathrm{.}6886956521739.$