View the original community article here
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.
This content is subject to limited support.