What are the answers to the following queries? (Use Set Operators such as UNION ALL, UNION, MINUS, INTERSECT). You can zoom in on the picture to see the snip of the structure of the tables, and base yourself on that to provide well answers.
ces31
PRODUCT_WAREHOUSE_QUANTITY CATEGORY_CATEGORY_NAME 1CPU COUNTRIES 2Video Card COUNTRY COUNTRYNAME 3RAM 4Mother Board 5Storage EMPLOYEES QUANTITY WAREHOUSE_LOCATIONS 888888888888888888888 ACCESS COUNTRY_DOMAIN ORDER_ITEMS -II ORDERS -PRODUCT CATEGORIES L CATEGORY_CATEGORY PRODUCT_NAME PRODUCT_NAME Riesta Loos LUST_PRICE REING REGION_ -...... LI REGION_NAME S- WAREHOUSES WAREHOUSE WAREHOUSE_NAME
2. Display the category ID, category name, and the number of products in category 2, 2, and 5. In your result, display first the number of products in category 5, then category 2. CATEGORY_CATEGORY_COLUMN 1CPU 522 2Video Card
3. Display product ID for products whose quantity in the inventory is greater than or equal to 5. (You are not allowed to use JOIN for this question.)
"n... 101
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 your answer.)
ESTATE
Jeree rokyo Poefe est1)
6GBPB 838 x 00 222
58 35000
-PIIG.