在表格存储中想通过月份分组得到相应统计聚合数据，请问大家有效率高点的替代方案吗？

在表格存储中想通过月份分组得到相应统计聚合数据，请问大家有效率高点的替代方案吗？

select
    case 
        when news_star_time>=1690819200 and news_star_time<1693497600 then '2023-08' 
        when news_star_time>=1693497600 and news_star_time<1696089600 then '2023-09' 
        when news_star_time>=1696089600 and news_star_time<1698768000 then '2023-10' 
        when news_star_time>=1698768000 and news_star_time<1701360000 then '2023-11' 
        when news_star_time>=1701360000 and news_star_time<1704038400 then '2023-12' 
        when news_star_time>=1704038400 and news_star_time<1706716800 then '2024-01' 
        when news_star_time>=1706716800 and news_star_time<1709222400 then '2024-02' 
        when news_star_time>=1709222400 and news_star_time<1711900800 then '2024-03' 
        when news_star_time>=1711900800 and news_star_time<1714492800 then '2024-04' 
        when news_star_time>=1714492800 and news_star_time<1717171200 then '2024-05' 
        when news_star_time>=1717171200 and news_star_time<1719763200 then '2024-06' 
        when news_star_time>=1719763200 and news_star_time<1722441600 then '2024-07' 
        when news_star_time>=1722441600 and news_star_time<1725120000 then '2024-08' 
        when news_star_time>=1725120000 and news_star_time<1727712000 then '2024-09' 
    end as time,
    count(*) as cishu,
    sum(news_zbje) as jine 
from 
    table_name
where 
    news_type=1
    and news_star_time between 1690819200 and 1725120000
    and news_xingzi <> '-'
    and new_Industry_father <> '99'
group by 
    time
order by 
    time ASC
limit 30