How to SORT results made with COUNT?

Databases
1

Hello,

I have to choose artists with biggest number of songs from DB.

To count the number of songs for each artist I use this query:

SELECT artis, COUNT(song) FROM lyric GROUP BY artis LIMIT 0,100;

I wonder is it possible to sort results by number of songs in the same MySQL query? Or I should use other methods to sort results?

2

of course it’s possible :slight_smile:

SELECT artis
     , COUNT(*) [COLOR="Blue"]AS songs[/COLOR]  FROM lyric 
GROUP 
    BY artis 
ORDER 
    BY [COLOR="blue"]songs [/COLOR]DESC LIMIT 0,100
3

Niiice :slight_smile:

Thanks a LOT.