Senior Backend Engineer / Stage 2 · Data
Query and join a small relational model
"Already know" meets prerequisites. "Not relevant" removes the topic from your total but leaves what builds on it waiting.
Self-check
- You have customers A and B; only A has an order. Write a query returning every customer and their order count, including zero for B.
- Evidence to include: Explain join type, the counted column and what changes if a filter moves from ON to WHERE.
Try it without the material first, then compare. Save your answer in your notes below. Report a problem with this self-check
Learning activities
3 activities- Not done2 min
- Not done7 min
- Not done5 min