Nested SQL SELECT Statements

Description:
Looking at why you may nest one SELECT statement into another, and a couple of examples of how this is done.

Made for OCR A Level Computer Science Paper 1 (H446).

Part of the 1.3.2 Databases topic: https://youtube.com/playlist?list=PL04uZ7242_M5ax0-xg06k1HnRiN7EmxeD&feature=shared
Full Paper 1 playlist: https://www.youtube.com/playlist?list=PL04uZ7242_M46xMfDhdEi1_DuJJ3qI4wl

0:00 What nesting means and why it is done
1:06 Example #1 - single table
3:32 Example #2 - across two tables