SELECT p.prod_name ,p.prod_id FROM products p INNER JOIN orderitems oi
ON oi.prod_id = p.prod_id AND oi.item_price >30 AND oi.order_num IN
(
SELECT o.order_num FROM orders o LEFT JOIN customers ct ON ct.cust_id = o.cust_id AND ct.cust_name = 'xxx'
)
SELECT p.prod_name ,p.prod_id FROM products p INNER JOIN orderitems oiON oi.prod_id = p.prod_id AND oi.item_price >30 AND oi.order_num IN( SELECT o.order_num FROM orders o LEFT JOIN customers