MySQL显示不带子查询的计数

Question

我有下面的表

>td style="text-align:right；">mypageurl/example>mypageurl/otherpagetd style="text-align:right；">3>td style="text align:right>td style="text align:righttherdomain/example<1><1>

Id	source_url
1	googlecom
2	googlecom	googlecom
4	googlecom
5	mypageurl/example	otherdomain/example
6	mypageurl/example
7	mypageurl/otherpage	其他域/示例

试试这个

SELECT URL, 
SUM(click) click, 
SUM(VISIT) visit 
FROM (SELECT CASE WHEN event_type=0 
THEN target_url 
ELSE source_url END      url, 
SUM(CASE WHEN event_type = 0 
THEN 1 
ELSE 0 END)          visit, 
SUM(CASE WHEN event_type = 1 
THEN 1 
ELSE 0 END)          click
FROM urlData
GROUP BY target_url, 
source_url,
event_type  ) A 
GROUP BY URL