Counting and Grouping Data Automatically. You can count and report the total number of rows that have the same value for one or more columns. ... In the SQL QUERY COLUMNS window, select DIVISION and < ...