S&P Global Interview Question

What are different joins?