find null and not null percentage

PHOTO EMBED

Mon Apr 25 2022 03:44:26 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select sum(case when no is null then 1 else 0 end) / Sum(1.00) as nullpercentage,
sum(case when no is not null then 1 else 0 end) / Sum(1.00) as notnullpercentage
from zzzzzz_csv as zc 
content_copyCOPY