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