Asked about Getting the data out
When do you use a LEFT JOIN?
An answer that works
When you need every row from the left side regardless of whether there is a match, and absence is meaningful. Watch the counting trap: COUNT(*) counts the unmatched row, COUNT(right_column) does not.
Reading an answer is not being able to give one. The section that teaches this is Getting the data out, 6 hours of SQL & data access.
Learn this properlyAlso asked about SQL & data access
What is the difference between WHERE and HAVING?A query is slow. How do you diagnose it?What is a window function for?Write a query for each user's most recent order.Why can NOT IN return nothing?What is the difference between COUNT(*) and COUNT(column)?A client retries a request after a timeout. How do you make sure it is not processed twice?What is a race condition in a read-modify-write, and how do you prevent it?