how to exclude zero in our counting

PHOTO EMBED

Tue Apr 05 2022 04:20:43 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

select count(*) as total
from pizza_runner.x_csv as xc
where no <> 0

select round(avg("no"),2), --count without excluding zero
 round(avg(nullif("no",0)),2) as r-- count with exluding zero
from pizza_runner.x_csv as xc 
content_copyCOPY