Can you show me the origins, the destinations and the flight numbers?
select origin, destination, flno from flight group by destination
Hmm, I want to know just the destinations and the flight numbers please.
select destination, flno from flight group by destination
Please show me the destinations and the number of flights they have.
select destination, count ( * ) from flight group by destination
Which destination has the least number of flights?
select destination, count ( * ) from flight group by destination order by count ( * ) limit 1