Uber Interview Question

What do nested SELECT and WITH do in SQL?