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
- SQ-101: Shop page lists products that were taken down
- SQ-102: Invoice shows ₹129 for a ₹129.99 item
- SQ-103: "Newest customers" widget ignores Mumbai
- SQ-104: "Orders without a coupon" always shows 0
- SQ-105: Ops dashboard: orders per status
- SQ-106: Login lookup can't find ' ASHA@mail.IN '
- SQ-107: City revenue counts cancelled orders
- SQ-108: Win-back email list is empty since guest checkout launched
L2 · Junior
- SQ-201: Order report doubles the units when an order has two payments
- SQ-202: Homepage "bestsellers" counts cancelled orders
- SQ-203: Gold tier picks customers by one big order
- SQ-204: Monthly revenue report has one row per day
- SQ-205: Support panel: friendly order labels and "Late" flag
- SQ-206: Average order value is wrong by a few rupees
- SQ-207: Category report hides categories with no sales
- SQ-208: Coupon share per city shows 0% everywhere
L3 · SDE-1
- SQ-301: "Your last order" shows an older imported order
- SQ-302: Diwali sale tracker: running revenue by day
- SQ-303: "Days since last order" compares different customers
- SQ-304: Category pages: top 2 sellers in each category
- SQ-305: Merge duplicate customer accounts
- SQ-306: City ops sheet: order statuses as columns
- SQ-307: Abandoned-cart job marked delivered orders as abandoned
- SQ-308: Supplier stock sync wipes reserved units
L4 · Senior
- SQ-401: "My orders" scans the whole orders table
- SQ-402: Streak badge counts any login days, not consecutive ones
- SQ-403: Checkout funnel shows more buyers than visitors
- SQ-404: Month-1 retention by signup cohort
- SQ-405: Delivery SLA uses the average, hiding the typical order
- SQ-406: Payment reconciliation misses orders with no payment
- SQ-407: Unique email check lets "Asha@Mail.in" through
- SQ-408: Order history page 2,000 takes 9 seconds
L5 · Staff
- SQ-501: Access review: everyone who reports to Arjun
- SQ-502: Breadcrumbs for every category page
- SQ-503: Audit log for price changes
- SQ-504: Referral leaderboard counts only direct invites
- SQ-505: Sessions per customer from raw clickstream
- SQ-506: Riders double-booked for overlapping delivery slots
- SQ-507: Revenue chart skips days with no sales
- SQ-508: Backfill imported order lines with the price on the order date
Loading editor…
Sign in to pick up this ticketEdit the code, run the checks and earn XP. Your drafts, XP and streak stay with your JioCoder account.
Sign in to editChecks