Accenture Interview Question

Sql query, rank function, views