SELECT cd.country AS  `Client Country` , COUNT( t.id ) AS  `Tickets Count` 
    FROM hb_tickets t
    JOIN hb_client_details cd ON ( cd.id = t.client_id ) 
    GROUP BY cd.country
    ORDER BY  `Tickets Count` DESC 
    LIMIT 30