CODE EXAMPLE FOR SQL

get count of null in column sql

select sum(case when a is null then 1 else 0 end) count_nulls
     , count(a) count_not_nulls 
  from us;