$18$ points each $-$ You must include a screen shot AND the sql query AND results in your answer. The screen shot must clearly display your user name: $8$ pts for the query, $7$ points for summarizing $/$ explaining the query results legibly, and $3$ pts for the screen shot.

$1.$ List all the different product categories and sub categories in alphabetical order, list only the product category and product subcategory. Sort by the product subcategory.

$2.$ How many ORDERS had a CRITICAL order$\_$priority? $[$Hint: you will use the function $\backslash (\backslash$operatorname$\{$COUNT$\}(*)]\backslash )$

$3.$ Display the order date and the ship date for all orders that were made April $1$ through April $15.$ List the order date, ship date, order priority, and ship mode. Order the results by order$\_$date. Do you notice anything unusual about the data? $[$Hint: You will need to join the orders and shipping together and use a join statement. You will need to limit the result set by the date field order$\_$date to$\_$date$(\text{'}04/15/2018\text{'},\text{'}$mm$/$dd$/$yyyy$\text{'}).]$

$4.$ How much sales and profit was made from the sales of COMPUTER PERIPHERALS $($Prod$\_8)?[$Hint: you will use the SUM function you will need a WHERE clause to filter the rows$].$

$5.$ List the sales, order$\_$quantity, and profit for all products in the TECHNOLOGY category. Display the product sub category name, the sales, order quantity, and profit. Order by the product sub category name. $[$Hint: you will need to join the market and product tables together and filter the rows by product category. You will also need an ORDER BY clause$].$