California State University, Sacramento

Our first work with advanced SQL is looking at places in a SQL statement that permit anonymous (un-named) nested queries. Later in the semester, nesting is extended by ways in which a nested query can be named and the referenced in other places within one larger query – this permits a query result to act like a named temporary table during execution of such multi-nested queries. ................
................