Question d’entretien chez Uber

What do nested SELECT and WITH do in SQL?