Capgemini interview question

he told me to write a basic sql query