SELECT within SELECT

This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries.

Exercises

Using nested SELECT.

To get a well rounded view of the important features of SQL you should move on to the next tutorial concerning aggregates.

To gain an absurdly detailed view of one insignificant feature of the language, read on.

We can use the word ALL to allow >= or > or < or <=to act over a list.

We can refer to values in the outer SELECT within the inner SELECT. We can name the tables so that we can tell the difference between the inner and outer versions.

The following questions are very difficult: