Capgemini Interview Question

Write Query joining 2 tables