What are the destinations and number of flights to each one?
SELECT destination ,  count(*) FROM Flight GROUP BY destination
destinations = destination; number of flights to each destination = COUNT(*);