]And what makes you think this is a real problem? Isn't it more likely a hypothetical question to teach a student how to solve a problem
I know this was not a real problem, I knew the nature of the question as you rightly pointed out for the student be able to understand problem solving.
How does MySQL sort a text file, and why would someone use it for this type of sort?
Again your right with regards to MYSQL sorting txt files. MySQL is a relational database management system (RDBMS) "for the benefit of the OP", but it nice to have a laugh once in a while & as for the "type of sort" that's a matter of personal opinion.
by Nick Evan: Replaced CODE-tags with QUOTE tags. CODE-tags are for CODE. QUOTE tags for QUOTES