Accenture interview question

Sql query, rank function, views