find percentage of null values in total

PHOTO EMBED

Wed Apr 13 2022 06:26:59 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

--- 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 
content_copyCOPY