Show me all the airports.
select * from airport
Show me the names of all airports.
select name from airport
Which of these airports start with the word 'international'?
select name from airport where name like "international%"
What about the ones that contains the word "international"?
select name from airport where name like '%international%'