Senior Backend Engineer / Stage 2 · Data

Query and join a small relational model

CoreFoundationDraft, not yet reviewed14 min of activities

"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

My notes

Saved on this device, synced when signed in
Esc
↑ ↓ to move↵ to open