我有一个按国家/地区汇总活跃客户的查询SELECTt1.Date,t2.country,sum(t1.countplayer)asPlayerCountFROM(SELECTCustomersASPlayer,Date,1ascountplayerFROMOnline_customer_activity_v2)t1JOIN`players`t2ONt1.`Player`=t2.`username`GROUPBYt1.Date,t2.countryLIMIT20;+------------+--------------+-------------+|Date|country|Player