帮忙看看 这三句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 
    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')

Answer 2

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

group by version