Skip to content
Advertisement

SQL – I need help How to COUNT all sales by month within a year

I can’t figure out a way to COUNT al transactions by month each YEAR on a single query. I figured out a way but for one month at a time, there’s a lot of data (time consuming)

this is the table

enter image description here

i want to have something like this

enter image description here

thank you

Advertisement

Answer

here is how you can do it , using extract to extract month /year from your date column and group by it:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement