Gopneg
public text v1 · immutableselect numGuns
from Classes c
where c.type = 'bb'
and numGuns is not null
---
8
8
9
9
12
12
select avg( numGuns )
from Classes c
where c.type = 'bb'
and numGuns is not null
--
9
select numGuns
from Classes c
where c.type = 'bb'
and numGuns is not null
---
8
8
9
9
12
12
select avg( numGuns )
from Classes c
where c.type = 'bb'
and numGuns is not null
--
9