• Thanks for the overview.

    It would be good to mention CTEs as well. In my opinion they are very usefull and much more readable than derived tables.