Quick Summary In MySQL you'll want to group by two fields YEAR(date), MONTH(date): SELECT YEAR(order_time), MONTH(order_time), COUNT(order_id) AS total_orders FROM orders GROUP BY 1, 2In PostgreSQL use the date_trunc('month', timestamp) function. SELECT date_