PHP search data table sorting

Search for a grade Table. Each item in the table contains the information of each person and the class field. Obviously, many people correspond to the same class, SQL statement that requires displaying the class information in descending order of the number of students

$ SQL   =   " Select ycid, count (*) as num from uch_ycuser group by ycid order by num DESC " ;
Mysql_query ( $ SQL );

 

Well, it's actually not hard. It's just the result of a lot of research.