what is the average shot volume (cm 3) when the shot diameter (cm) is less than 6.04?
CREATE TABLE table_name_73 (shot_volume__cm_3__ INTEGER, shot_diameter__cm_ INTEGER)
SELECT AVG(shot_volume__cm_3__) FROM table_name_73 WHERE shot_diameter__cm_ < 6.04
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (shot_volume__cm_3__ INTEGER, shot_diameter__cm_ INTEGER) Question: what is the average shot volume (cm 3) when the shot diameter (cm) is less than 6.04? [/INST] SELECT AVG(shot_volume__cm_3__) FROM table_name_73 WHERE shot_diameter__cm_ < 6.04 </s>