select count(distinct hostname) as unique_hostnames, 
       count(*) as record_count
from my_table 
where clean_hostname is null