instruction: Visualize a bar chart for what is the name of each aircraft and how many flights does each one complete?, and could you sort by the Y-axis from high to low?
response: SELECT name, COUNT(*) FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid GROUP BY T1.aid ORDER BY COUNT(*) DESC