Doris取每个季度 时间维度内的topN条数据，对应的sql查不出来怎么办？

SELECT date, gtsx, row_num
FROM (SELECT CONCAT(YEAR(date), '-Q', QUARTER(date))                                              AS date,
             first_value(`gtsx`) over (PARTITION BY YEAR(date), QUARTER(date) ORDER BY date DESC) AS gtsx,
             ROW_NUMBER() over (PARTITION BY YEAR(date), QUARTER(date) ORDER BY date DESC)        as row_num
      FROM doris_dzw_demo_v1) AS ranked_data
where row_num=1
ORDER BY date desc;



SELECT date, gtsx, row_num
FROM (SELECT CONCAT(YEAR(date), '-Q', QUARTER(date))                                       AS date,
             gtsx,
             ROW_NUMBER() OVER (PARTITION BY YEAR(date), QUARTER(date) ORDER BY date DESC) AS row_num
      FROM doris_dzw_demo_v1) AS ranked_data
where row_num=1
ORDER BY date desc;