Uber interview question

What do nested SELECT and WITH do in SQL?