Capco interview question

Do some basic SQL queries, the the java coding challenge