Detecting Gaps in a Sequence
Given a table quiz_orders(order_id, customer_id, order_date) where order_id should be consecutive daily numbers, list any missing order_ids
These are the tables to query for this question:
bootcamp.quiz_ordersYour answer should include these columns:
- missing_id integer
Querying is only for logged in users!
Sign In