MySQL 不同条件查询条数 count带条件

 select  count(1)  from origin_crx_data  where create_time like '2019-02-23%' and source='12345'

 select  count(1)  from origin_crx_data  where active_time like '2019-02-23%' and source='12345'

合并为一条sql

SELECT
sum(case when create_time like '2019-02-23%' then 1 else 0 end) as inst_count,
sum(case when active_time like '2019-02-23%' then 1 else 0 end) as active_count
FROM  origin_crx_data   where source='12345'