Table: pratt_whitney_r_985
Columns: engine
power_continuous
critical_altitude_this_is_the_highest_altitude_at_which_the_engine_can_achieve_its_full_continuous_power_rating_above_this_altitude_power_falls_off_with_height_as_with_a_naturally_aspirated_engine_see_supercharger_altitude_effects_for_details
power_takeoff
compression_ratio
supercharger_gear_ratio
octane_rating
dry_weight

Question: What was the compression ration when the engine was Wasp Jr. T1B2?
SQL: SELECT "compression_ratio" FROM pratt_whitney_r_985 WHERE "engine" = 'Wasp Jr. T1B2'

Question: What is the compression ration when the continuous power is hp (kw) at 2,200 RPM and the octane rating is 80/87?
SQL: SELECT "compression_ratio" FROM pratt_whitney_r_985 WHERE "power_continuous" = 'hp (kW) at 2,200 RPM' AND "octane_rating" = '80/87'

Question: What is the compression ratio when the continuous power is  hp (KW) at 2,200 RPM and the critical altitude is at sea level?
SQL: SELECT COUNT("compression_ratio") FROM pratt_whitney_r_985 WHERE "power_continuous" = 'hp (kW) at 2,200 RPM' AND "critical_altitude_this_is_the_highest_altitude_at_which_the_engine_can_achieve_its_full_continuous_power_rating_above_this_altitude_power_falls_off_with_height_as_with_a_naturally_aspirated_engine_see_supercharger_altitude_effects_for_details" = 'sea level'

Question: When the engine is Wasp Jr. T1B2, what is the number needed for takeoff power?
SQL: SELECT COUNT("power_takeoff") FROM pratt_whitney_r_985 WHERE "engine" = 'Wasp Jr. T1B2'

Question: When critical altitude is sea level, what is the compression ration for a supercharger gear ratio of 7:1?
SQL: SELECT "compression_ratio" FROM pratt_whitney_r_985 WHERE "critical_altitude_this_is_the_highest_altitude_at_which_the_engine_can_achieve_its_full_continuous_power_rating_above_this_altitude_power_falls_off_with_height_as_with_a_naturally_aspirated_engine_see_supercharger_altitude_effects_for_details" = 'sea level' AND "supercharger_gear_ratio" = '7:1'