SQL HAVING 子句和group by ,count配合去重

https://m.baidu.com/from=844b/bd_page_type=1/ssid=0/uid=0/pu=usm@1,sz@1320_2001,ta@iphone_1_10.3_3_603/baiduid=44321CE30B5EDD26A15339F553306A5C/w=0_10_/t=iphone/l=3/tc?ref=www_iphone&lid=13769566713511522503&order=1&fm=alop&tj=www_normal_1_0_10_title&vit=osres&m=8&srd=1&cltj=cloud_title&asres=1&title=SQLHAVING子句&dict=20&w_qd=IlPT2AEptyoA_yixHVWoJSO5AEhSjWS&sec=23257&di=240ea65b049de71b&bdenc=1&tch=124.0.253.227.0.0&nsrc=IlPT2AEptyoA_yixCFOxXnANedT62v3IEQGG_zcHATm7ok_rxP4kHRhdXHKhVmiHH9Cb9nGPfLBNcT0yQT1si210&eqid=bf1753f8bde5b0001000000659939e80&wd=&clk_info={"srcid":"1599","tplname":"www_normal","t":1502846597526,"sig":"4889","xpath":"div-div-div-a-p"}&sfOpen=1



计算group by分组的数据，统计，协助查询条件