Accenture interview question

complex oracle queries mainly on window functions