List the count and id of each product in all the orders.
SELECT count(*) ,  T3.product_id FROM orders AS T1 JOIN order_items AS T2 JOIN products AS T3 ON T1.order_id = T2.order_id AND T2.product_id = T3.product_id GROUP BY T3.product_id
SELECT count(*) ,  T3.product_id FROM orders AS T1 JOIN order_items AS T2 JOIN products AS T3 ON T1.order_id = T2.order_id AND T2.product_id = T3.product_id GROUP BY T3.product_id
[{'count(*)': 1, 'product_id': 1}, {'count(*)': 2, 'product_id': 3}, {'count(*)': 2, 'product_id': 4}, {'count(*)': 1, 'product_id': 7}, {'count(*)': 1, 'product_id': 8}, {'count(*)': 2, 'product_id': 11}, {'count(*)': 1, 'product_id': 12}, {'count(*)': 2, 'product_id': 14}, {'count(*)': 3, 'product_id': 15}]