Cvent interview question

SQL 1 puzzle Based on resume