--- using sum case when to find the percentage of null value
select sum(case when no is null then 1 else 0 end) / Sum(1.00) as nullpercentage,
sum(case when no = 'jason' then 1 else 0 end) / Sum(1.00) as notnullpercentage
from zzzzzz_csv as zc