如何将三句 mysql 查询合并为一句？
原有三句查询如下：
select count(*) as tp_count from `qra_works` where `created_time` > '2023-05-10 18:44:37' limit 1 select count(*) as tp_count from `qra_works` where `created_time` > '2023-05-10 18:44:37' and `version` = 'junior' limit 1 select count(*) as tp_count from `qra_works` where `created_time` > '2023-05-10 18:44:37' and `version` = 'senior' limit 1
这些查询执行三次，影响效率。可以通过使用 group by 子句将它们合并为一句查询：
SELECT
version, COUNT(*) AS tp_count
FROM
`qra_works`
WHERE
`created_time` > '2023-05-10 18:44:37'
GROUP BY
version此查询将返回版本和相应数量，类似于原始查询的结果。
