Question d’entretien chez Anonymous

Complete the given sql Query and how you approached it ?