Please write SQL statements for part C and D given the table. Part C is just fill-in the blank, part D is entirely blank

Requirement 3b: - Select customers who are located in CA, FL, PA, or NY - For each of the order lines associated with the selected customers, display Order_ID, Customer_ID, Customer_Name, Product_ID, Ordered_Quantity - Sort the result set by Order_ID in an ascending order SELECT o.Order_ID, _..Cusotmer_ID, FROM Customer_T AS c, Order_T AS o,___ AS ol WHERE c.Customer_ID = AND o.Order_ID = ol. AND Customer_State ORDER BY _..Order_ID; Requirement 3d: - Select products that are priced under $800 and made with Cherry or Walnut - For each order line associated with the selected products, display Order_ID, Order_Date, Product_ID, Product_Description, Product_Finish and Ordered_Quantity (hint: join 3 tables) - Sort the result set first by Product_ID in an ascending order and by Ordered_Quantity in a descending order