Skip to content
Foundations · drill

How many, and how many priced

For each customer id that has orders, return the id, how many orders they placed, and how many of those have a total. Call the columns customer_id, placed and priced. Order by customer_id.

Your query

⌘⏎