CREATE TABLE Invoices (order_id VARCHAR)

Show the order ids and the number of invoices for each order.
SELECT order_id, COUNT(*) FROM Invoices GROUP BY order_id
SELECT "order_id", COUNT(*) FROM "Invoices" GROUP BY "order_id"