Table: scotts_pass
Columns: name
mi_from_kingston
km_from_kingston
parish
length_feet
length_meters

Question: What is Name, when Length Meters is greater than 66.4, and when Km From Kingston is 138.8?
SQL: SELECT "name" FROM scotts_pass WHERE "length_meters" > 66.4 AND "km_from_kingston" = 138.8

Question: What is the total number of Length Feet, when Parish is Clarendon, when Km From Kingston is 71.2, and when Length Meters is less than 21.3?
SQL: SELECT COUNT("length_feet") FROM scotts_pass WHERE "parish" = 'clarendon' AND "km_from_kingston" = 71.2 AND "length_meters" < 21.3

Question: What is the highest Km From Kingston, when Mi From Kingston is less than 108, and when Length Meters is 260.6?
SQL: SELECT MAX("km_from_kingston") FROM scotts_pass WHERE "mi_from_kingston" < 108 AND "length_meters" = 260.6

Question: What is Lenth Feet, when Mi From Kingston is greater than 84.5, when Length Meters is greater than 55.5, and when Name is Unnamed?
SQL: SELECT "length_feet" FROM scotts_pass WHERE "mi_from_kingston" > 84.5 AND "length_meters" > 55.5 AND "name" = 'unnamed'