Table: cities_latlong
Columns: latitude
longitude
city
state
country

Question: What city in Svalbard has a longitude of 15°39′e?
SQL: SELECT "city" FROM cities_latlong WHERE "state" = 'svalbard' AND "longitude" = '15°39′e'

Question: If the latitude is 77°28′n, what is the longitude?
SQL: SELECT "longitude" FROM cities_latlong WHERE "latitude" = '77°28′n'

Question: If the latitude is 76°25′n, what is the longitude?
SQL: SELECT "longitude" FROM cities_latlong WHERE "latitude" = '76°25′n'

Question: If the latitude is 71°18′n, what is the longitude?
SQL: SELECT "longitude" FROM cities_latlong WHERE "latitude" = '71°18′n'