select country,client,COUNT(DISTINCT msisdn) as 'Total_number_of_MSISDN',count(*) as 'Total_number_of_MSISDN',
count(case when COUNT(DISTINCT msisdn) then 1 end )
from my_table
where CAST(time_updated as DATE) = CURRENT_DATE-1
and action_status='COMPLETED' and "ACTION" ='CHARGE'
GROUP BY country,client
order BY country,client