Genesys interview question

SQL joins scenario based and window functions