🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.A missing ORDER BY
  2. B.The GROUP BY is on the wrong column
  3. C.An inner JOIN that drops students with no submissions
  4. 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 →