Question

1. Develop an SQL that will list PID, Name, Unit_Cost of products that have more than 50 units in the

Inventory.

2. Develop an SQL that will list all PID, Name, Unit_Cost for products related to warehouse 2 OR in-transit for warehouse 2 [Hint: UNION].

3. Develop an SQL that will list Division Name and the Name of the Manager for the Main Division.

4. Develop an SQL that will list WID, Street_No, City, and State for all warehouses that have multiple shipment records.

5. Develop an SQL that will list EID and Name of Employees who are managers but do not manage any department. Please note that Employees who are managers their Mgr_EID <> 0.