Quest Global Interview Question

How many joins and their functionality