The table below contains repeating groups and multivalued attributes. Order_ID Order_Date Cust_ID Cust_Name Cust_Loc Pro

[answerhappygod]

The table below contains repeating groups and multivalued attributes. Order_ID Order_Date Cust_ID Cust_Name Cust_Loc Prod_ID Prod_Desc Prod_Price Qty_Sold 1031 20/06/22 C0045 ABC Ltd Spanish Town P00101 P00025 P00150 Dell Laptop Computer Desk Desk Lamp 150,000 45,000 2,500 3 5 5 1012 21/06/22 C0021 Learners Haven May Pen P02050 P00220 Projector Tablet 112,000 500 2 10 Description of Fields: Order_ID = unique ID assigned to each order; Order_Date = date the order was placed; Cust_ID = unique ID assigned to each customer; Cust_Name = name of customer; Cust_Loc = city location of the customer; Prod_ID = unique ID assigned to each product; Prod_Desc = description of the product; Prod_Price = price of the product; Qty_Sold = quantity of the product sold 3.
Write SQL statements to provide information regarding the following: All products with 2 or less quantities sold. Include the description of the products, the customers, and any other relevant field(s). A calculated field showing the total amount due for each product purchased by Learners Haven. Include all relevant fields in the