HRS Group interview question

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