查询最新的3条数据，总和，最小值，有判定条件

select * from (SELECT *,MIN(huanshoulv) as minh,min(zhandifu) as minz ,sum(zhandifu) as sumz
                FROM (
                    SELECT *,
                                 ROW_NUMBER() OVER (PARTITION BY code ORDER BY date desc) AS row_num
                    FROM stock
            ) AS sub_query WHERE row_num <= 3  GROUP BY code) as hh WHERE  minh >=10 and minz >=0 and sumz<10