QUESTION 01
When does a LEFT JOIN behave like an INNER JOIN?
You need every customer, including customers with no paid order. What is wrong with placing `o.status = 'PAID'` in the WHERE clause after a LEFT JOIN, and how would you correct it?
14 days · built for experienced developers
A focused backend interview sprint for developers who know how to build systems—but need to explain trade-offs clearly when the interview starts.
Free practice room
Five real questions from the sprint. No email required.
QUESTION 01
You need every customer, including customers with no paid order. What is wrong with placing `o.status = 'PAID'` in the WHERE clause after a LEFT JOIN, and how would you correct it?
Inside the sprint
Each session takes 30–45 minutes. You attempt first, compare your reasoning, then mark what needs another pass.
Concurrency, collections, JVM reasoning
Joins, indexes, query behaviour
Contracts, modelling, consistency
Kafka, retries, idempotency
Caching, scale, trade-offs
Ownership, incidents, outcomes
Founding pilot
Get the complete 28-page sprint workbook and use the 14-day plan to practise one focused module at a time. Founding customers can send feedback directly as we improve future editions.
FOUNDING ACCESS
Every example explains why the answer works and where it can fail.
Trade-offs, incidents, ownership and follow-up questions—not trivia alone.
You mark what you can explain independently. We do not invent a hiring score.