SQL语句从一个结果集二次查询,看了下文档,好像没有可以用的,直接写原生的吗?本人小白

麻烦有写过类似的看一下哈哈,谢谢

select 
    `plat_id` ,
    `package_id`,
    count(account)as recharge_num
from 
    (
        SELECT 
            plat_id,
            package_id,
            account, 
            created_at
        FROM cz_charges 
        where created_at between '2020-11-15 00:00:00' and '2020-11-15 23:59:59' 
        group by account 
        having created_at between '2020-11-15 02:00:00' and '2020-11-15 02:59:59            
    ) as a   
group by package_id