Data about the flights of a certain airline are stored in the flights table. In the table, there are columns such as destination and length. The first stores the name of the airport to which the plane is headed, and the second stores the flight length in miles.
Write a query that groups flights by destination airport and displays only those with a minimum flight length greater than 500 miles. The output should contain the destination airport and the minimum flight length as well.