PwC interview question

basic SQL and previous projects