Finastra interview question

How do I search the specific information in SQL and sort it?