google query label replacement when using "group by"

Words
67
Reading
1 min
Listen
Play
8y

Google query function return data ranges's header when using "group by".

The header includes property. Such as count, sum.

You can use as below.

=QUERY(F2:G4,"SELECT F, SUM(G) GROUP BY F LABEL SUM(G) '합' ",1)

F2:G4 is data range.

[label is not used]
구분 | sum count {colname}
col1 | col2

[label is used]
구분 | 합
col1 | col2

You can express it more clearly and pretty.

google query label replacement when using "group by" | Ecency