[Google Spreadsheet] How to realize group by function in Google Spreadsheet?

Assume I have the following raw data:

We can make good use of query function to meet group by requirement:

Check the result:

Reference
[1] https://webapps.stackexchange.com/questions/36103/how-to-group-data-in-a-google-spreadsheet