529 questions · 10 company databases
Prepare for SQL interviews on databases that look like the real thing
Practise on realistic companies: an online store, a ride-hailing app, food delivery, streaming, a bank, ad-tech, healthcare, edtech, B2B SaaS and logistics. Every question comes with hints, a model answer that has been run against the company's tables, an explanation and the mistakes interviewers watch for.
Get ShopX free
All 68 ShopX questions, free for good. Verify your email to create your account.
Try 28 questions without signing up
Full question, hints, model answer and explanation, exactly as in the course.
ShopX · beginner
Basic customer list
ShopX · beginner
Distinct countries
ShopX · beginner
Customer count
ShopX · beginner
Premium customers
ShopX · beginner
Low-price products
ShopX · beginner
Most expensive products
ShopX · beginner
Orders by status
ShopX · intermediate
Revenue by country
ShopX · intermediate
Customers with no orders
ShopX · advanced
Top 3 products per category by revenue
RideGo · beginner
The first 20 riders to sign up
RideGo · beginner
Distinct rider cities
Foodly · beginner
The first 20 customers
Foodly · beginner
Customer cities
StreamFlix · beginner
The first 10 users to sign up
StreamFlix · beginner
Users by country
FinTrust · beginner
Active accounts by type
FinTrust · beginner
Customers who joined in the last 90 days
AdSphere · beginner
Active campaigns
AdSphere · beginner
Campaigns per channel
HealthNow · beginner
Patients by city
HealthNow · beginner
The 10 oldest patients
EduPro · beginner
Published courses per category
EduPro · beginner
Beginner courses under ₹1,000
SaaSCloud · beginner
Customers by segment
SaaSCloud · beginner
Plan price list
LogisticsX · beginner
Warehouse capacity by region
LogisticsX · beginner
This week's shipments by status
What every question includes
A real schema for every company
Each company has its own set of tables with keys, nullable columns and messy edges, the way production databases look.
Hints before the answer
Reveal one hint at a time, so you can get unstuck without seeing the whole solution.
Model answers that have been run
Every model answer and alternative has been executed in PostgreSQL against sample data for its company's tables.
Explanations and a checklist
Why the query works, what an interviewer listens for, and a checklist to mark your own answer.
The mistakes that cost offers
Common wrong turns for each question: fan-out joins, NULLs in NOT IN, integer division, WHERE vs HAVING and more.
Mock interview rounds
Business-style questions in the words a hiring manager would use, where you have to choose the definition first.
The companies
Each company is a separate database with its own business questions.
| Company | Domain | Beginner | Intermediate | Advanced | Mock | Access |
|---|---|---|---|---|---|---|
| ShopX | E-commerce (Amazon-style) | 15 | 15 | 28 | 10 | Free |
| RideGo | Ride-hailing | 13 | 15 | 21 | 5 | ₹99 |
| Foodly | Food delivery | 12 | 16 | 21 | 10 | ₹99 |
| StreamFlix | Video streaming | 12 | 15 | 26 | 5 | ₹99 |
| FinTrust | Digital banking / fintech | 10 | 12 | 21 | 5 | ₹99 |
| AdSphere | Ad-tech / digital marketing | 10 | 10 | 23 | 5 | ₹99 |
| HealthNow | Healthcare / EMR | 10 | 12 | 22 | 5 | ₹99 |
| EduPro | EdTech / online learning | 10 | 11 | 22 | 5 | ₹99 |
| SaaSCloud | B2B SaaS / subscription analytics | 10 | 10 | 24 | 5 | ₹99 |
| LogisticsX | Logistics / supply chain | 10 | 10 | 23 | 5 | ₹99 |
Pricing
One company
₹99
Any one of the 9 paid companies, all its questions and mock round, for 30 days.
Choose a companyOne-time payments through Razorpay. No subscription, nothing renews automatically.
Questions
Do I need to install a database?
No. Each question shows the tables you need, you write your query in the workbook, then compare it with the model answer, explanation and checklist. Your query is not executed; the model answers have been run in PostgreSQL against sample data.
Which SQL dialect do the answers use?
PostgreSQL. Where another database (MySQL, SQL Server) needs different syntax, such as FILTER or DISTINCT ON, the explanation or an alternative answer says so.
What do I get free?
10 ShopX questions are open to everyone without signing up. With a free account (email verified) you get all 68 ShopX questions, with no time limit.
How does paid access work?
Each paid company costs ₹99 for 30 days. The bundle of all 9 paid companies costs ₹699 for 30 days. It is a one-time payment, not a subscription; nothing renews automatically.
What level are the questions?
Every company has beginner, intermediate and advanced questions. Beginner covers SELECT, filters, sorting and simple aggregates; intermediate covers joins, HAVING, conditional aggregation and dates; advanced covers window functions, CTEs, cohorts, retention, attribution and data-quality checks.
Prepared by TechNet Consultancy, Anand.