多表数据统计后拼接

select
T1.name,
IFNULL(T1.joinNum, 0) AS joinNum,
IFNULL(T2.jhNum, 0) AS jhNum
from
(SELECT
IFNULL( province, ‘其他’ ) AS name,
count( DISTINCT user_id ) AS joinNum
FROM out_prize
GROUP BY province) as T1
left join
(SELECT
IFNULL( province_name, ‘其他’ ) AS name,
SUM(CASE WHEN TO_DAYS(NOW())-TO_DAYS(login_date) > 0 THEN 1 ELSE 0 END) AS jhNum
FROM user
GROUP BY province_name) as T2
on T1.name = T2.name