滚动周计算收益率的SQL

例：某quote表，有tradedate,closeprice的字段数据，现在要取最近一周到52周每周的收益率

用SQL语名实现如下MAX_WEEK找出每周最后一个交易日及其收盘价，同时MIN_WEEK是取每周第一个

交易日的收盘价。

select MAX_WEEK.stkcode,        MAX_WEEK.year_week,        ((MAX_WEEK.closeprice - MIN_WEEK.closeprice) / MIN_WEEK.closeprice) DRate   from (select B.stkcode, B.year_week, A.closeprice           from quote A,                (select stkcode,                        Concat(T_year, wkCount) as year_week,                        max(tradedate) M_tradedate                   from (select stkcode,                                tradedate,                                substr(tradedate, 0, 4) T_year,                                closeprice,                                to_char(to_date(tradedate, 'yyyy-mm-dd'), 'iw') as wkCount                           from quote                          where stkcode = '816020'                          order by tradedate desc) C                  group by T_ye