帮忙看看 这三句mysql能不能写成一句？

Question

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 

帮忙看看 这三句mysql能不能写成一句？
感觉执行3次影响效率，不知道为什么写成一句，该怎么写？

Answer 1

SELECT 
    version, COUNT(*) AS tp_count 
FROM 
    `qra_works` 
WHERE 
    `created_time` > '2023-05-10 18:44:37' 

group by version

Answer 2

SELECT 
    COUNT(*) AS total_count,
    SUM(CASE WHEN version = 'junior' THEN 1 ELSE 0 END) AS junior_count,
    SUM(CASE WHEN version = 'senior' THEN 1 ELSE 0 END) AS senior_count
FROM 
    qra_works
WHERE 
    created_time > '2023-05-10 18:44:37'

Answer 3

SELECT 
    COUNT(*) AS tp_count 
FROM 
    `qra_works` 
WHERE 
    `created_time` > '2023-05-10 18:44:37' 
    OR (`created_time` > '2023-05-10 18:44:37' AND `version` = 'junior') 
    OR (`created_time` > '2023-05-10 18:44:37' AND `version` = 'senior')