Show order ids and the number of products in each order.
create table order_items (order_id varchar, product_id varchar, PRIMARY KEY (order_id))
select order_id, count(distinct product_id) from order_items group by order_id