easy5 pts · first answer countssql

Listing users with zero orders

A report must list every user with their number of orders, including users who have never ordered. Which query shape is correct?

A.FROM users u INNER JOIN orders o ON o.user_id = u.id ... COUNT(*)B.FROM users u RIGHT JOIN orders o ON o.user_id = u.id ... COUNT(*)C.FROM users u LEFT JOIN orders o ON o.user_id = u.id ... COUNT(o.id)D.FROM users u CROSS JOIN orders o ... COUNT(o.id)

← Optional property in strict mode Comparing a column to NULL →