It looks like the Make Aggregation Query Layer tool creates an inner join by default. It would help if users could choose to use a left join instead, via a parameter in the tool, since the purpose of the tool is to facilitate analysis without the need to write SQL.
