Meta Interview Question

SQL question + Case + Stats