select * from crosstab( 'select extract(year from starts) as year, extract(month from starts) as month, count(*) from events group by year, month order by year, month', 'select * from month_count' ) as ( year int, jan int, feb int, mar int, apr int, may int, jun int, jul int, aug int, sep int, oct int, nov int, dec int ) order by year;
Comments
0 B
|👍
/👎
0 B
|👍
/👎