Question: SQL problem: Using the UNION, UNION ALL, INTERSECT and MINUS statements find: A. The order_id of the orders that include a product from artist 'Burt
SQL problem:
Using the UNION, UNION ALL, INTERSECT and MINUS statements find:
A. The order_id of the orders that include a product from artist 'Burt Ruggles' and include products from 'Jess & Odie'.
B. The order_id of the orders that include a product from artist 'Burt Ruggles' or include products from 'Jess & Odie'.
C. The order_id of the orders that include a product from artist 'Burt Ruggles' or include products from 'Jess & Odie' Desk, listing this time all the results, even if the same salesperson is repeated. E. Repeat all the previous queries without using set operators.
D. Repeat all the previous queries without using set operators.

INVOICES ITEMS - ITEM_ID 1 TITLE 0 ARTIST 1 UNIT_PRICE 22 ORDER_DETAILS ORDER_ID ITEM_ID * ORDER_QTY ORDER_T ORDERI INET
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
