The order_id of the orders that include a product from artist 'Burt Ruggles' and include products from 'Jess & Odie.

SELECT ORDER_ID FROM ORDER_DETAILS O INNER JOIN ITEMS I ON O.ITEM_ID = I.ITEM_ID WHERE I.ARTIST = 'Burt Ruggles' INTERSECT SELECT ORDER_ID FROM ORDER_DETAILS O INNER JOIN ITEMS I ON O.ITEM_ID = I.ITEM_ID WHERE I.ARTIST = 'Jess & Odie';

Repeat the query above but this time do not use UNION. Hint: You will need to use a subquery

Connections + DOESBUSINESSIN_T - EMPLOYEE_T + EMPLOYEESKILLS_T D GENERAL_LEDGER_ACCOUNTS + INVOICE_LINE_ITEMS - INVOICES ITEMS 0 ITEM_ID I TITLE ARTIST - UNIT_PRICE 0 ORDER_DETAILS - ORDER_ID 1 ITEM_ID L ORDER_QTY 0 ORDER_T + 0 ORDERLINE_T # 2 ORDERS + PAYMENT_T # E PAYMENTTYPE T