Most data sort

[HaidarPesebe]

Dear All,

I need your help to how to call the database.

I've got a mysql database as follows:
------------------
Name | qty
-----------------
 A     1
 B     2
 A     4
 A     1
 B     1
 A     2
 C     2
 D     1
 C     4

How calling if I want to sort the data according to the most, or the result will look like
this

A = 7
C = 6
B = 3
D = 1

Thanks a lot
Haidarpesebe