Monthly Bar Graph Postgresql DB

[andreapraja11]

i mean my x series graph based on pic that i posted, sort from Apr22, Apr 23, Aug 22, Aug 23, … , Sep22, Sep 23. how to sort into a sequence of months (Jan22, Feb 22, Mar22, … , Nov23, Dec23)

[yosiasz]

Ah gotcha.
What if you just do order by date

[andreapraja11]

i already tried but here’s the result

and then i also changed the group by, but the data change like this