每个大区最多可支持的用户ID数量（）

A.100000个ID B.110000个ID C.118000个ID D.128000个ID

A.16000个ID B.17000个ID C.18000个ID D.19000个ID

A.5 B.6 C.7 D.8

A.1 B.2 C.3 D.4

A.40 B.88 C.22 D.80

A.60mH2O B.70mH2O C.80mH2O D.90mH2O

A.select prod_id， user_id， count(*) as cnt from t_order group by prod_id，user_id having cnt <=10 B.select * from ( select prod_id， user_id， cnt， row_number() over (partition by prod_id order by cnt desc) as rn from (select prod_id， user_id， count(*) as cnt from t_order group by prod_id，user_id) a ) b where rn <=10 C.select * from ( select prod_id， user_id， cnt， row_number() over (partition by user_id order by cnt ) as rn from (select prod_id， user_id， count(*) as cnt from t_order group by prod_id，user_id) a ) b where rn <=10 D.select * from ( select prod_id， user_id， cnt， row_number() over (partition by user_id order by cnt desc) as rn from (select prod_id， user_id， count(*) as cnt from t_order group by prod_id，user_id) a ) b where rn <=10

A.3 B.4 C.5 D.6

A.5 B.7 C.11

A.3个 B.4个 C.5个 D.6个