#SQL面試#大佬們來幫幫孩子吧,寫不出來渾身難受商品表goods有三行數(shù)值:gid,price,date。表示商品每天的價格,求商品id在date日期時的價格price為最近X天內(nèi)的最低價。例:gid,price,date1, 4, 2023-08-011, 3, 2023-08-021, 2, 2023-08-031, 3, 2023-08-04輸出:gid,price,date,X1, 4, 2023-08-01,1(近一天最低價)1, 3, 2023-08-02,2(近兩天最低價)1, 2, 2023-08-03,3(近三天最低價)1, 3, 2023-08-04,1(近一天最低價)