hive中关于SUM(COUNT(1))的用法实践测试用例

SELECT * FROM temp.tmp_20181026 T;
+------------+-----------+-----------+----------+--+
| t.classes  |  t.name   | t.course  | t.score  |
+------------+-----------+-----------+----------+--+
| a1         | zhangsan  | math      | 90       |
| a1         | zhangsan  | eng       | 80       |
| a1         | zhangsan  | phy       | 70       |
| a1         | lisi      | math      | 60       |
| a1         | lisi      | eng       | 85       |
| a1         | lisi      | phy       | 77       |
| a2         | wangwu    | math      | 90       |
| a2         | wangwu    | eng       | 90       |
| a2         | wangwu    | phy       | 90       |
| c1         | mazi      | chinese   | 100      |
| c1         | mazi      | eng       | 60       |
| c1         | mazi      | phy       | 98       |
| d1         | haha      | chinese   | 50       |
| d1         | haha      | eng       | 30       |
| d1         | haha      | phy       | 9        |