Capgemini interview question

Basic Tree questions, round robin, joins in SQL