mysql - 一个嵌套 sql 查询中的两个查询

Question

我想把两条sql语句合二为一。第一个显示每天下达的订单总数，第二个仅显示每天有员工作为操作文本的订单数。

select date(dated) date_ord, count(*) as orders_placed
from stats.sales_actions 
group by date_ord 
order by dated desc

select date(dated) date_order, count(*) as orders_modified
from stats.sales_actions 
where action_text LIKE '%STAFF%'
group by date_ord 
order by dated desc

如果可能，我想在一个表/sql 查询中显示。

Answer 1

只需使用UNION:

select date(dated) date_ord, count(*), 'orders_places' as orders_placed
from stats.sales_actions 
group by date_ord 
order by dated desc
UNION
select date(dated) date_order, count(*), 'orders_modified' as orders_modified
from stats.sales_actions 
where action_text LIKE '%STAFF%'
group by date_ord 
order by dated desc