Accenture interview question

Code snippets etc. SQL queries.