Essex Lake interview question

SQL and analytics based questions