Finastra Interview Question

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