Can I include an aggregate in a sql_on: clause?

[molly_lippsett]

Knowledge Drop

Last tested: Jul 1, 2020

Nope - in SQL order of operations, joins come before aggregation, therefore you can’t have an aggregate in the sql_on: or any ON clause in a join.