Avanade Interview Question

They asked a question around database administration and how I would write a query to pull/join different tables