Ingham ISD Interview Question

how to make complex sql query simple?