Table: transmission_ratios
Columns: tag_id
application
torque_rating
1st
2nd
3rd
4th
5th
6th
rev
input_splines
output_splines

Question: What is the rev of the 2003-2004 Mustang Cobra?
SQL: SELECT "rev" FROM transmission_ratios WHERE "application" = '2003-2004 Mustang Cobra'

Question: What is the rev for all of the  Aston Martin applications?
SQL: SELECT "rev" FROM transmission_ratios WHERE "application" = 'Aston Martin'

Question: What is the 3rd ratio for tag number 1386-000-017 and input splines of 26?
SQL: SELECT "3rd" FROM transmission_ratios WHERE "input_splines" = 26 AND "tag_id" = '1386-000-017'

Question: What is the 2nd ratio of 1996-2002 Dodge Viper?
SQL: SELECT "2nd" FROM transmission_ratios WHERE "application" = '1996-2002 Dodge Viper'

Question: What application has a 6th ratio of 0.50:1 and 350 as a torque rating?
SQL: SELECT "application" FROM transmission_ratios WHERE "6th" = '0.50:1' AND "torque_rating" = 350