Confused on what I’m doing wrong.

select distinct order_id, count(1)

from order_items

group by 1

order by 1;

The question asks:

Let’s calculate the reorder ratio for all of SpeedySpoon’s products and take a look at the results. Counting the total orders per product is straightforward. We count the distinct order_ids in the order_items table.

Complete the query by passing in the distinct keyword and the order_id column name into the count function

select name, /**/

from order_items

group by 1

order by 1;

Here’s a hint on how to use the count function to count distinct columns in a table.