GOAT Group Interview Question

SQL questions consisted of CASE WHENs, self joins, Window functions