Table: gymnast_results
Columns: year
competition_description
location
apparatus
rank_final

Question: What is the highest Year, when Apparatus is "Vault", and when Rank-Final is less than 9?
SQL: SELECT MAX("year") FROM gymnast_results WHERE "apparatus" = 'vault' AND "rank_final" < 9

Question: What is Year, when Competition Description is "U.S. Championships", when Rank-Final is less than 3, and when Apparatus is "All-Around"?
SQL: SELECT "year" FROM gymnast_results WHERE "competition_description" = 'u.s. championships' AND "rank_final" < 3 AND "apparatus" = 'all-around'

Question: What is Apparatus, when Rank-Final is greater than 6, and when Competition Description is "U.S. Championships"?
SQL: SELECT "apparatus" FROM gymnast_results WHERE "rank_final" > 6 AND "competition_description" = 'u.s. championships'