通过它找到最常见的价值和订单

Question

+-----------------------+------------------------+
| being_followed        | follower               |
+-----------------------+------------------------+
| Bob Dylan             |                      B |
| Bob Dylan             |                      A |
| Sam Cooke             |                      X |
| The Beatles           |                      Y |
| Bob Dylan             |                      M |
| Sam Cooke             |                      N |
+-----------------------+------------------------+

Now, I want to find which is the most occurring value in being_followed and then order by it. It should look somewhat like -

Bob Dylan - 3
Sam Cooke - 2
The Beatles - 1

Please don't mark this as a duplicate.

Answer 1

Try This:-

select being_followed,count(*) total_followers
from table
group by being_followed
order by total_followers desc