Table: gun_specs_2
Columns: gun_class_pdr
shot_diameter_cm
shot_volume_cm_3
approx_service_bore_cm
mass_of_projectile_kg

Question: How many times is the shot volume (cm3) less than 172.76?
SQL: SELECT COUNT("shot_diameter_cm") FROM gun_specs_2 WHERE "shot_volume_cm_3" < 172.76

Question: what is the average shot volume (cm 3) when the shot diameter (cm) is less than 6.04?
SQL: SELECT AVG("shot_volume_cm_3") FROM gun_specs_2 WHERE "shot_diameter_cm" < 6.04