question: Who is from the united states, has a rank less than 9, and heat more than 5?
answer: SELECT name FROM table_name_79 WHERE rank < 9 AND heat > 5 AND nationality = "united states"
context: CREATE TABLE table_name_79 (name VARCHAR, nationality VARCHAR, rank VARCHAR, heat VARCHAR)