| 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”这个人也经历过前面的三个等级!