Question d’entretien chez Razer

How would you join / perform these queries