Table: crime_rates
Columns: crime
reported_offenses
killeen_rate
texas_rate
u_s_rate

Question: Texas Rate smaller than 32.9, and a U.S. Rate larger than 5.6 is what highest killeen rate?
SQL: SELECT MAX("killeen_rate") FROM crime_rates WHERE "texas_rate" < 32.9 AND "u_s_rate" > 5.6

Question: Reported Offenses larger than 216, and a U.S. Rate smaller than 3274, and a Texas Rate smaller than 2688.9, and a Crime of violent crime has what killeen rate?
SQL: SELECT SUM("killeen_rate") FROM crime_rates WHERE "reported_offenses" > 216 AND "u_s_rate" < 3274 AND "texas_rate" < 2688.9 AND "crime" = 'violent crime'

Question: Killeen Rate of 511.6, and a Texas Rate smaller than 314.4 is the lowest reported offenses?
SQL: SELECT MIN("reported_offenses") FROM crime_rates WHERE "killeen_rate" = 511.6 AND "texas_rate" < 314.4