| id | kind | grade | event |
| 101_10000 | b | 1 | GLOBULINS DECREASED |
| 101_10000 | b | 1 | HYPERTRIGLYCERIDAEMIA |
| 101_10000 | b | 1 | LEUKOCYTOSIS |
| 101_11100 | b | 1 | BLOOD CREATINE PHOSPHOKINASE INCREASED |
| 101_11100 | b | 3 | GLOBULINS DECREASED |
| 101_11100 | b | 1 | HYPERTRIGLYCERIDAEMIA |
| 101_11100 | b | 1 | HYPOPHOSPHATAEMIA |
| 101_11100 | b | 1 | HYPOAESTHESIA ORAL |
| 101_11100 | b | 4 | PROTEIN TOTAL DECREASED |
| 101_11100 | b | 1 | XANTHELASMA |
| 101_13700 | a | 1 | ALANINE AMINOTRANSFERASE INCREASED |
| 101_13700 | a | 1 | ALANINE AMINOTRANSFERASE INCREASED |
| 101_13700 | a | 3 | ANAEMIA |
| 101_13700 | a | 1 | ASPARTATE AMINOTRANSFERASE INCREASED |
| 101_13700 | a | 1 | ASPARTATE AMINOTRANSFERASE INCREASED |
| 101_13700 | a | 4 | BLOOD CHOLESTEROL INCREASED |
| 101_13700 | a | 1 | MUSCLE SPASMS |
| 101_13700 | a | 1 | OEDEMA PERIPHERAL |
| 101_13700 | a | 1 | OEDEMA PERIPHERAL |
| 101_13700 | a | 1 | PAIN IN EXTREMITY |
| 101_13700 | a | 1 | FOLLICULITIS |
| 101_13700 | a | 2 | FOLLICULITIS |
| 101_13700 | a | 1 | FOLLICULITIS |
| 101_13700 | a | 1 | GAMMA-GLUTAMYLTRANSFERASE INCREASED |
| 101_13700 | a | 1 | GLYCOSYLATED HAEMOGLOBIN INCREASED |
| 101_13700 | a | 1 | HYPERCHOLESTEROLAEMIA |
| 101_13700 | a | 1 | HYPERGLYCAEMIA |
是这样的,现在需要统计按四个grade的两组kind的id人头数和event事件数
| kind | grade | 人数 | 事件数 |
| a | 1 | | |
| a | 2 | | |
| a | 3 | | |
| a | 4 | | |
| b | 1 | | |
| b | 2 | | |
| b | 3 | | |
| b | 4 | | |
不过有条最关键的规则就是:不论人头数还是事件数,只计算最高等级的,也就是说像‘101_11100’这个人经历过grade4这个等级,那么久不再计入grade1~grade3这三个等级,虽然“101_11100”这个人也经历过前面的三个等级!