ITSS 3300 SQL Assignment Upl ORDERS PK Order id NUMBER(5) Order_date DATE Order Priority VARCHAR2(10) Ord VARCHAR2(10) PRODUCT PK Prod id VARCHARCO Pred_Category VARCHAR220) Prod Sub Category VARCHAR(20) MARKET PK Mt_id NUMBER Ord VARCHAR2(20) FK Prodd VARCHAR2(10) FK Ship VARCHAR2(10) Custid VARCHAR2(10) Sales NUMBER(5.2) Discount NUMBER(2.23 Order_Qui NUMBER(S) Pront NUMBER(S.2) Shipping cost NUMBER(S.2) Product_Base_Margir NUMBER(S2) SHIPPING PK Ship_id VARCHAR2(10) Ship Mode VARCHAR2(20) Ship Date DATE FK Order Id Number (5) 1707 D Focus 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 COUNT(*) ] 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