Domanda di colloquio di Razer

How would you join / perform these queries