Infosys Interview Question

joins , cte , union, select , disticnt