Table: qf_3inch_20cwt_data
Columns: m_v_ft_s
shell_lb
time_to_ft_m_at_25_seconds
time_to_ft_m_at_40_seconds
time_to_ft_m_at_55_seconds
max_height_ft

Question: What is the average maximum height of a shell that travels for more than 16.3 seconds at 55° and has a maximum velocity of 2200 ft/s?
SQL: SELECT AVG("max_height_ft") FROM qf_3inch_20cwt_data WHERE "time_to_ft_m_at_55_seconds" > 16.3 AND "m_v_ft_s" = 2200

Question: What is the maximum amount of time a shell travels at 55° when it traveled less than 9.6 seconds at 40°?
SQL: SELECT MAX("time_to_ft_m_at_55_seconds") FROM qf_3inch_20cwt_data WHERE "time_to_ft_m_at_40_seconds" < 9.6

Question: What is the weight of the shell that reached its maximum height at 40° in 12.6 seconds?
SQL: SELECT "shell_lb" FROM qf_3inch_20cwt_data WHERE "time_to_ft_m_at_40_seconds" = 12.6

Question: What is the average maximum height of the shell smaller than 12.5 lb that reached its maximum height at 25° in 10.1 seconds?
SQL: SELECT AVG("max_height_ft") FROM qf_3inch_20cwt_data WHERE "time_to_ft_m_at_25_seconds" = '10.1' AND "shell_lb" < 12.5