instruction: Find the number of students whose age is older than the average age for each gender, and I want to sort by the x axis in desc.
response: SELECT Sex, COUNT(*) FROM Student WHERE Age > (SELECT AVG(Age) FROM Student) GROUP BY Sex ORDER BY Sex DESC