KPMG Interview Question

Walk me through a simple SQL query.