KPMG interview question

Walk me through a simple SQL query.