用sql查詢每個月的資料筆數

select year(prod_date),month(prod_date),count(*) from product
group by year(prod_date),month(prod_date)
order by year(prod_date),month(prod_date)