SQL JOIN Debugging: Duplicates and Missing Rows

SQL JOIN Debugging: Duplicates and Missing Rows

Answer 15 questions randomly selected from a bank of 30. Choose one best answer per question. Pass with 12 correct answers. Original practice material, not an official certification exam.
1 из 15
A LEFT JOIN counts orders per customer. Which expression avoids counting the unmatched placeholder row when order.id is non-null for real orders?