查询根据代码分组后的前四条日期最大的数据

SELECT
stockcode,
sum(

IF (
isnull(baseEarnings) || LENGTH(trim(baseEarnings)) < 1 ,- 10000,
baseEarnings
)
) AS baseEarnings
FROM
(
SELECT
stockcode,
statisticsDate,
baseEarnings
FROM
data_stock_key_indicators_season a
WHERE 4 > (
SELECT
count(1)
FROM
data_stock_key_indicators_season
WHERE
stockcode = a.stockcode
AND date(statisticsDate) > date(a.statisticsDate)
)
ORDER BY
a.stockcode,
a.statisticsDate DESC
) t
GROUP BY
stockcode