GROUP BY is often unnecessary since it is already implicit in the query. For this reason, we chose to interpret GROUP BY implicitly in QuestDB.
So both examples would run fine without GROUP BY.
select artist, count(artist) as artist_count from dbo.music_charts
select artist, song, count(artist) as artist_count
where artist = 'mariah carey'
order by artist_count desc, song, artist;
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.