WNS-Vuram interview question

Sql query for select and column selection