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