clear

Use China, Japan and Korea

Select the sum (IIF(yw & gt；; = 85, 1, 0)) is' YW is not less than 85';

Sum (IIF(yw & gt；; =60, 1, 0)) is' YW is not less than 60';

Sum (IIF(sx & gt；; = 85, 1, 0)) is' Sx is not less than 85';

Sum (IIF(sx & gt；; = 60, 1, 0)) as' Sx is not less than 60';

Sum (IIF(YY & gt；; = 85, 1, 0)) is' YY is not less than 85';

Sum (IIF(YY & gt；; = 60, 1, 0)) is' YY is not less than 60';

From cjk

Group by Beijing