[atarashi]

The HAVING clause is evaluated before the SELECT so you have to specify the full clause `having sum(weight) > 12` and not just the alias. Most SQL engines are probably smart enough to not actually recalculate everything.

[cema]

Yes, SQL engines tend to be much smarter than the SQL languages as such.