Most candidates can write the query. The ones who get the offer can also explain what could go wrong. Each kit gives you the trap, the follow-up and a ready answer, so the tough question never catches you off guard.
40K+ subscribers already learn SQL from the CodeEra YouTube channel"GROUP BY m.name. Looks fine."
Interviewer: "What if two managers are both called Sam?"
"...uh. I haven't thought about that."
"I group by emp_id as well as name, so two Sams stay separate, and LEFT JOIN so managers with zero reports still appear."
Interviewer: "Why not COUNT(*)?"
"It would count the unmatched NULL row as 1."
Tick only the ones you could explain out loud, with the fix, if an interviewer asked.
Question 27 is open. The trap, the follow-up and the perfect answer are not. Every one of the 60 questions has all three, and the other kits go just as deep.
Unlock everything for ₹299This is the kind of trap the workbooks teach you to spot. Pick an answer and see why.
| emp_id | name | manager_id |
|---|---|---|
| 1 | Sam | NULL |
| 2 | Sam | NULL |
| 3 | Ria | 1 |
| 4 | Dev | 1 |
| 5 | Mia | 2 |
SELECT m.name, COUNT(e.emp_id) AS reports FROM Employee m LEFT JOIN Employee e ON e.manager_id = m.emp_id GROUP BY m.name;
CodeEra teaches SQL, DBMS, Java and interview experiences on YouTube, free. These kits are the structured, interview-ready version of that teaching: solved questions, traps and answer scripts in one place.
Hover a cover for a peek inside. Add two or more and we'll show you if the bundle is cheaper.
Two questions, one recommendation.
A day-by-day plan from zero SQL to entry-level analyst skills.
CodeEra is a YouTube channel that teaches SQL to 40K+ subscribers. You can watch the free videos first and judge the teaching for yourself.
The download link opens right after payment and is also emailed to you.
Yes. Every kit has a few free sample pages. Hover a cover and tap Preview pages.
These are digital downloads, so all sales are final once delivered. Look through the sample pages first.
The examples are written for MySQL and PostgreSQL style SQL. Notes call out where Oracle or SQL Server differ.
Pay by UPI, card or net banking on Razorpay. We never see your card details.