TransUnion interview question

MySQL query for some a huge table