SQL同表查询两个条件如何将两表结果匹配并横向并起来
select [政策名称] ,count(*) 数量 from [电渠日报新].[dbo].[电商匹配] WHERE [下单时间] LIKE '2021-08-24%' group by [政策名称]
select [政策名称] ,count(*) 数量 from [电渠日报新].[dbo].[电商匹配] WHERE [激活时间] LIKE '2021-08-24%' group by [政策名称]
select [政策名称] ,count(*) 数量 from [电渠日报新].[dbo].[电商匹配] WHERE [下单时间] LIKE '2021-08-24%' group by [政策名称]
select [政策名称] ,count(*) 数量 from [电渠日报新].[dbo].[电商匹配] WHERE [激活时间] LIKE '2021-08-24%' group by [政策名称]