PORTFOLIO · SQL FOR DATA ANALYSIS
Ade O.
3 competencies · 25 receipts · 2 Sep – 15 Oct 2026
83%
Average score
68
Readiness Score
Competencies
RECEIPT № 0193⛨ INTEGRITY INTACT
QUESTION
Explain what a LEFT JOIN returns when there is no matching row.
LEARNER’S ANSWER
All rows from the left table, with NULL in the right table’s columns where nothing matches.
RESULT
✓ Correct · matched 2 of 2 key points
ISSUED
14 Oct 2026, 19:42
EVIDENCE · SQL JOINS EXPLAINED · 12:41–13:05✓ LINKED
“…a left join keeps every row on the left, and fills the right side with null where nothing matches.”
Source live · matches capture of 14 Oct 2026