The most annoying is having to order by DESC NULLS LAST to get the largest value from an aggregation.