请统计:每个店铺的UV(访客数)(同一用户访问同一店铺多次算一次)
分析:Visit表的字段有三个:user_id, shop, UV
sql如下:
select shop,count(*) as UV from (select shop,user_id from Visit group by shop,user_id)group by shop;
请统计:每个店铺的UV(访客数)(同一用户访问同一店铺多次算一次)
分析:Visit表的字段有三个:user_id, shop, UV
sql如下:
select shop,count(*) as UV from (select shop,user_id from Visit group by shop,user_id)group by shop;