06B
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
-- 06b: Find customers with no order of any status
SELECT c.customer_id,c.customer_name FROM aabha_sql.customers AS c
LEFT JOIN aabha_sql.orders AS o ON o.customer_id=c.customer_id
WHERE o.order_id IS NULL ORDER BY c.customer_id;