Description
1. Display cities that no warehouse is located in them. (use set operators to answer this
question)
2. Display the category ID, category name, and the number of products in category 1, 2,
and 5. In your result, display first the number of products in category 5, then category 1
and then 2.
3. Display product ID for products whose quantity in the inventory is less than to 5. (You
are not allowed to use JOIN for this question.)
4. We need a single report to display all warehouses and the state that they are located in
and all states regardless of whether they have warehouses in them or not. (Use set
operators in you answer.)
Example Submission
— ***********************
— Name: Your Name
— ID: #########
— Date: The current date
— Purpose: Lab 4 DBS311
— ***********************
— Question 1 – Copy the question from above here
— Q1 SOLUTION —
SELECT * FROM TABLE;
— Question 2 – Copy the question from above here
— Q2 Solution –
SELECT * FROM TABLE;
