Innovacx interview question

SQL - Multiple SQL Queries on Joins and Window Functions