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
⌘⏎