Runs a SQL-like query (using Google's query language) on a range to filter, aggregate, and sort data.
=QUERY(A2:C100, "SELECT A, SUM(C) WHERE B='East' GROUP BY A") might sum column C by category A for rows where B is "East".
