笔试面试 表:test id(主键) guid term_type os_type 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 49D4566D-A4F3-46CE-AB6A-E8D536AC5CC9 49D4566D-A4F3-46CE-AB6A-E8D536AC5CC9 65367231-ea2c-4f56-9835-6fcde476816d 65367231-ea2c-4f56-9835-6fcde476816d 65367231-ea2c-4f56-9835-6fcde476816d 83b6b81b-a076-4b4c-9b99-f60a88795eb3 83b6b81b-a076-4b4c-9b99-f60a88795eb3 83b6b81b-a076-4b4c-9b99-f60a88795eb3 a129264b-b6bb-4beb-b683-901a4753a4f5 a129264b-b6bb-4beb-b683-901a4753a4f5 AB938BB1-1F68-42C3-9C0E-F4228174D992 AB938BB1-1F68-42C3-9C0E-F4228174D992 BA7794D0-85B8-436C-B7AC-AA5B196CE574 BA7794D0-85B8-436C-B7AC-AA5B196CE574 CE75E817-C83A-4E2C-97C3-01D72D4F7D64 CE75E817-C83A-4E2C-97C3-01D72D4F7D64 CE75E817-C83A-4E2C-97C3-01D72D4F7D64 eb5d0f60-e862-44fc-97eb-1e69fe4ec8df eb5d0f60-e862-44fc-97eb-1e69fe4ec8df eb5d0f60-e862-44fc-97eb-1e69fe4ec8df 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 2 2 2 ios ios android android android android android android android android ios ios ios ios ios ios ios android android android term_type =2 and os_type =ios —–iphone term_type =3 and os_type =ios —–ipad term_type =2 and os_type =android —安卓phone term_type =3 and os_type =android —安卓pad 根据guid去重后,按照设备的term_type 和os_type,判断设备类型,计算每种设备的数量