order by most frequent occurence sql : I have a table  CARDUSR.SPPAYTB with transaction informations. The table contains ACAUREQ_AUREQ_ENV_M_CMONNM which is the Common Merchant Name. 

Now I want an output like this:

    orders           ACAUREQ_AUREQ_ENV_M_CMONNM     
    ---------+---------+----------------
    100               Antique Shop    
    30                Airleisure    
    23                Books 
    12                ....        

 How can I contruct the "orders" column which is the count of all transaction with a certain common merchant name?