7a) Write an SQL query for the BIG Z INC database that displays all the information in the DEPOT table for large depots

7b) Write an SQL query for the BIG Z INC database that displays for each customer in the zipcode 60137 the customer id and name.

7c) Write an SQL query for the BIG Z INC database that displays the name of the product and the name of the products supplier.

7d) Write an SQL query for the BIG Z INC database that displays the zip-code and the number of customers in that zip-code

7e) Write an SQL query for the BIG Z INC database that displays the product id, name, and the number of orders in which the product appeared, for each product.

7f) Write an SQL query for the BIG Z INC database that displays the customer id, name, type and zip, for each customer who made an order on 1-Jan-2021.

7g) Write an SQL query for the BIG Z INC database that displays all zip codes where depots are located (do not repeat the same information twice).

7h) Write an SQL query for the BIG Z INC database that displays the order id, the quantity of all ordered products (as totalitems) and the name of the order clerk, for all orders whose quantity of all ordered products is greater than 10.

7i) Write an SQL query for the BIG Z INC database that displays the supplier id, supplier name, and the quantity of all ordered products (as totalitems), for all suppliers whose quantity of all ordered products is greater than 20.

BIG Z INC Observe the BIG Z INC DATABASE Big Z Inc ER Diagram DepotZip Depot Size ProductName DepotID ProductID Supplier D SupplierName Product Type DEPOT PRODUCT Supplies th SUPPLIER Quantity Ships From Includes CustomerName CustomerZip ORDERCLERK A Processes ORDER Submits TH CUSTOMER OCID OCName OrderID Order Date CustomerID Customer Type Big Z Inc Relational Schema SUPPLIER SupplierID SupplierName ORDERCLERK OCID OCName INCLUDES ProductID OrderID (FK) Quantity ORDER OrderID Order Date OCID (FK) DepotID (FK) CustomerlD (FK) PRODUCT ProductID ProductName Product Type SupplierID (FK) DEPOT DepotID DepotZip Depot Size CUSTOMER CustomerID CustomerName CustomerZip Customer Type Big Z Inc Data CustomerID C1 ORDER OrderID 01 02 03 04 05 06 C2 DepotID D1 D1 D2 D2 INCLUDES ProductID P1 P2 P1 P2 OCID OC1 OC2 OC3 OC1 OC2 OC3 Order Date 1-Jan-2021 2-Jan-2021 2-Jan-2021 3-Jan-2021 3-Jan-2021 3-Jan-2013 C3 OrderID 01 01 02 03 Quantity 4 8 12 4 C2 D3 D3 P3 P3 04 05 C3 7 5 8 4 P2 P1 06 06 PRODUCT ProductID P1 P2 ProductName Big Gripper Traction Wiz SureStart ProductType Tire Tire Battery SupplierID ST ST SUPPLIER SupplierID ST P3 BE SupplierName Super Tires Batteries Etc BE CUSTOMER CustomerID C1 CustomerName Auto Doc Bo's Car Repair JJ Auto Parts Customer Type Repair Shop Repair Shop Retiailer CustomerZip 60137 60140 60137 DEPOT DepotID D1 DepotZip 60611 C2 DepotSize Small Large Large C3 D2 60660 D3 60611 ORDERCLERK OCID OC1 OC2 OC3 OCName Antonio Wesley Lilly