Optum Interview Question

Query to join a table and sort it in descending order on a field