SELECT name FROM airports WHERE elevation BETWEEN -50 AND 50
Find the name of airports whose altitude is between -50 and 50.
SELECT name FROM airports WHERE elevation BETWEEN -50 AND 50
select name from airports where elevation between value and value
Find the name of airports whose altitude is between -50 and 50 .