HRS Group Interview Question

SQL Joins, Union and Union all, window functions, etc.