Nice list of questions. Thanks.

Could someone provide an example from question 10 where "HAVING without GROUP BY" works.

The SQL doc says you can do this and it behaves like...