user: Question: what is the average shot volume (cm 3) when the shot diameter (cm) is less than 6.04?
Columns: ['gun class (pdr.)', 'shot diameter (cm)', 'shot volume (cm 3 )', 'approx. service bore (cm)', 'mass of projectile (kg)']
Types: ['real', 'real', 'real', 'real', 'real']
Sample row: [2.0, 6.04, 172.76, 6.64, 0.90846]
SQL:

assistant: SELECT AVG("shot volume (cm 3 )") FROM "Table" WHERE "shot diameter (cm)" < 6.04;