顾名思义GROUP BY用在SELECT查询语句中，对数据进行分组操作。

    它的使用语法结构如下：

    SELECT column1, column2 FROM 表名 WHERE 条件 GROUP BY column1, column2 ORDER BY column1, column2

    示例如下：

    1. SELECT Name, COUNT(Name) AS TotalCount FROM YourTableName WHERE Deleted = 0 GROUP BY Name ORDER BY Name DESC;