TransUnion Interview Question

MySQL query for some a huge table