Group by, arrays, maps, reduce, and more — The SQL GROUP BY statement allows to create of groups of related data and then apply aggregate functions like SUM, MIN, or MAX. Consider the following LocationsReport table storing the number of the company locations per city. Country | City | No
Italy | Rome…