SQL isn't syntax. It's how you stop being fooled by numbers.

Beat 3 interview traps in 3 minutes. Each one is a thinking habit interviewers look for. For freshers and career switchers preparing for Data, Business and Product Analyst roles.

Each query looks right. Run it, decide if the answer is right, and fix it. Hints only if you want them.

Trap 1 of 3

What's the total revenue from Mumbai? This query looks right.

order_id	customer	city	amount	status	coupon
101	Asha	Mumbai	1200	completed	NEW10
102	Ravi	Mumbai	800	cancelled	NULL
103	Asha	Mumbai	500	completed	NULL
104	Neha	Delhi	900	completed	FEST
105	Kabir	Mumbai	300	completed	NULL
106	Ravi	Pune	700	completed	NULL

SELECT SUM(amount) AS revenue
FROM orders
WHERE city = 'Mumbai';

Edit it, or just run it first. Your call.

Why it works

Not just right or wrong

Get one wrong and you see the clause to look at and the rows you missed or added. You learn the fix, not just the answer.

Your way counts

A join, a subquery or a CTE: if your answer is correct, it's marked correct, and the explanation follows your method.

Messy data, like at work

35 tables with the duplicates, NULLs and missing weeks interviewers test, not tidy toy tables.

What ChaturIQ is

A free website for learning SQL and practising for analyst interviews. It has 28 lessons, 324 practice questions with every trap explained, and timed checkpoint tests, all on 35 realistic business tables. Everything runs in your browser; there is nothing to install or pay for.

Why we ask you to sign in

The challenge above needs no account. Sign in with Google only to save your progress, XP and streaks. Google shares your name, email address and profile photo, and we use them only for your ChaturIQ account. We never sell your data or show ads. Read our privacy policy and terms.

Your next interview has a SQL round. Be ready.

Built by Mohit Khandelwal, 5+ years in analytics, who learned SQL from YouTube and couldn't find interview-level practice. Read the story