hard20 pts · first answer countswindow-functionssqljoins

Order count of zero after a LEFT JOIN

Customers are LEFT JOINed to orders. A customer with no orders shows order_count = 1 with COUNT(*) OVER (PARTITION BY c.id). How do you fix it?

A.Use COUNT(*) OVER ()B.Use ROW_NUMBER() OVER (PARTITION BY c.id)C.Switch the LEFT JOIN to a RIGHT JOIND.Use COUNT(o.order_id) OVER (PARTITION BY c.id)

Discussion 0

Join free to post in the discussion.

Order count of zero after a LEFT JOIN

Discussion 0

Related questions