Well, the "fun" one to consider is IMO not that, but this:

    SELECT (SELECT sum(a + x) FROM xx LIMIT 1) FROM aa;

Making a pretty diagram where all the behaviours from various DBMSs are listed is left as an exercise to the author. :)