select hostname, count(*) cnt
from the_table 
where clean_hostname is null
group by hostname
order by count(*) desc