这两个sql如何合并

Question

SELECT from_unixtime(regtime, '%Y%m%d') dt , count(*) num from android_user group by dt order by dt desc limit 20; SELECT from_unixtime(regtime, '%Y%m%d') dt , count(*) num from android_user where `parent_id` <> '' group by dt order by dt desc limit 20; 最后得到一张表，安日期分组，第二张图日期没有的num为0？？求大神指导

Answer 1

SELECT from_unixtime(regtime, '%Y%m%d') dt , sum(case when parent_id='' then 0 else 1 end) num from android_user group by dt order by dt desc limit 20;

Answer 2

你这个是一张表吧？可以使用一条sql语句呀。
SELECT from_unixtime(regtime, '%Y%m%d') dt , count(*) num from android_user where `parent_id` <> '' group by dt order by dt desc limit 20;