Show all the pilot names and ages?
select name, age from pilot
What are the names that are older younger than 50?
select name from pilot where age <= 50
How about 30 or younger?
select name from pilot where age <= 30
Sort them in reverse alphabetical order?
select name from pilot where age <= 50 order by name desc