Accenture Interview Question

complex oracle queries mainly on window functions