Amazon Flex Interview Question

Ctes and subqueries in sql, advanced functions of excel