I have a table structure that looks like this:

```
ClassId
ClassDescription

```

My table's data looks like this:

```
ClassId  ClassDesc
4           --- 
4           ---  
4           ---
4
4
2
2
2

```

Now what I am trying to do is to get the count of `classId` based on each individual `classId` meaning, as an example, the above table would return a count of 5 for all of classId = 4 and a count of 3 for classId = 2.

So my Sql statement Count them individually and Order BY DESC On Count of ClassId  

4 counts to 5  

2 counts to 3

The final output should look like this:

```
ClassId       ClassDesc
    4           ----  
    2           ----

```