CREATE TABLE table_47437 ("gun class  ( pdr. ) " FLOAT, "shot diameter  ( cm ) " FLOAT, "shot volume  ( cm 3  ) " FLOAT, "approx. service bore  ( cm ) " FLOAT, "mass of projectile  ( kg ) " FLOAT)

what is the average shot volume (cm 3) when the shot diameter (cm) is less than 6.04?
SELECT AVG("shot volume (cm 3 )") FROM table_47437 WHERE "shot diameter (cm)" < '6.04'
SELECT AVG("shot volume (cm 3 )") FROM "table_47437" WHERE "shot diameter (cm)" < '6.04'