--- 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
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter