这样的sql能优化吗，每次子查询只有条件不同

Question

1 select * from
2 (select count(*) as '计划任务' from hscdm_project_qc where task_date BETWEEN date_add(now(),interval -7 DAY ) and NOW() ) as t1,
3 (select count(*) as '报送数据' from hscdm_project_qc where task_status =2 and task_date BETWEEN date_add(now(),interval -7 DAY ) and NOW()  )as t2,
4 (select count(*) as '审核通过' from hscdm_project_qc where check_status=1 and task_date BETWEEN date_add(now(),interval -7 DAY ) and NOW()  ) as t3

服务器端和客户端都好 

Answer 1

count(case when .. then ...  end)   SELECT COUNT(1) AS '计划任务', COUNT(CASE WHEN TASK_STATUS = 2 THEN 1 END) AS '报送数据', COUNT(CASE WHEN TASK_STATUS = 1 THEN 1 END) AS '审核通过' FROM HSCDM_PROJECT_QC WHERE TASK_DATE BETWEEN DATE_ADD(NOW(), INTERVAL - 7 DAY) AND NOW()

Answer 2

哪里需要优化呢?

Answer 3

大部分内容都是一样的 就只有个别条件不同  想看看能不能优化一下

Answer 4

可以试下 case 。。。。 then 。。。when语句