Please show me the destinations and the number of flights they have.
SELECT destination, count ( * )  FROM Flight GROUP BY destination
destinations refers to destination; number of flights they have refers to COUNT(*);