← Quiz: Checking AI-Written SQL: all 10 questions
Quiz: Checking AI-Written SQL · Question 2 of 10
"List every student with their submission count" returns 3 rows, but there are 5 students. What is the most likely caus…
"List every student with their submission count" returns 3 rows, but there are 5 students. What is the most likely cause?
- A.A missing ORDER BY
- B.The GROUP BY is on the wrong column
- C.An inner JOIN that drops students with no submissions
- D.COUNT(*) instead of COUNT(column)
Answer & explanation
Correct answer: An inner JOIN that drops students with no submissions
A LEFT JOIN keeps every student.
Can you get the rest right without peeking?
Take the timed Quiz: Checking AI-Written SQL quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →