查询最新的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