Skip to main content
SQLSQL LabJioCoder

SQL Lab: practice SQL on real production tickets

Practice SQL on 40 real-world tickets, Intern to Staff: joins, GROUP BY, window functions, CTEs, indexes and upserts, run with real SQLite in your browser. Free.

L1 · Intern

  1. SQ-101: Shop page lists products that were taken down
  2. SQ-102: Invoice shows ₹129 for a ₹129.99 item
  3. SQ-103: "Newest customers" widget ignores Mumbai
  4. SQ-104: "Orders without a coupon" always shows 0
  5. SQ-105: Ops dashboard: orders per status
  6. SQ-106: Login lookup can't find ' ASHA@mail.IN '
  7. SQ-107: City revenue counts cancelled orders
  8. SQ-108: Win-back email list is empty since guest checkout launched

L2 · Junior

  1. SQ-201: Order report doubles the units when an order has two payments
  2. SQ-202: Homepage "bestsellers" counts cancelled orders
  3. SQ-203: Gold tier picks customers by one big order
  4. SQ-204: Monthly revenue report has one row per day
  5. SQ-205: Support panel: friendly order labels and "Late" flag
  6. SQ-206: Average order value is wrong by a few rupees
  7. SQ-207: Category report hides categories with no sales
  8. SQ-208: Coupon share per city shows 0% everywhere

L3 · SDE-1

  1. SQ-301: "Your last order" shows an older imported order
  2. SQ-302: Diwali sale tracker: running revenue by day
  3. SQ-303: "Days since last order" compares different customers
  4. SQ-304: Category pages: top 2 sellers in each category
  5. SQ-305: Merge duplicate customer accounts
  6. SQ-306: City ops sheet: order statuses as columns
  7. SQ-307: Abandoned-cart job marked delivered orders as abandoned
  8. SQ-308: Supplier stock sync wipes reserved units

L4 · Senior

  1. SQ-401: "My orders" scans the whole orders table
  2. SQ-402: Streak badge counts any login days, not consecutive ones
  3. SQ-403: Checkout funnel shows more buyers than visitors
  4. SQ-404: Month-1 retention by signup cohort
  5. SQ-405: Delivery SLA uses the average, hiding the typical order
  6. SQ-406: Payment reconciliation misses orders with no payment
  7. SQ-407: Unique email check lets "Asha@Mail.in" through
  8. SQ-408: Order history page 2,000 takes 9 seconds

L5 · Staff

  1. SQ-501: Access review: everyone who reports to Arjun
  2. SQ-502: Breadcrumbs for every category page
  3. SQ-503: Audit log for price changes
  4. SQ-504: Referral leaderboard counts only direct invites
  5. SQ-505: Sessions per customer from raw clickstream
  6. SQ-506: Riders double-booked for overlapping delivery slots
  7. SQ-507: Revenue chart skips days with no sales
  8. SQ-508: Backfill imported order lines with the price on the order date
SQLquery.sql
Loading editor…
Build (SQLite 3)SQLite 3 · sql.js
Checks