Apply filter and aggregate together

This article describes Classic Fusion Tables.
The same features are offered in the New look, too.

Filtering and aggregation can be combined to a limited extent.

If you apply a filter and then click on the Aggregate tab, you are aggregating only the rows that satisfied the filter. If you perform an aggregation and then click on the Filter tab, the new filter you create applies to the rows of the table upon which the aggregation was performed, but you cannot set filters on the aggregation columns.

For SQL fans, this means we do not yet support the HAVING clause, but predicates in the WHERE clause can be specified even after aggregation.