Quest Global interview question

How many joins and their functionality