sqlite 범위지정후 SUM 하기

sqlite 범위지정후 SUM 하기 

SELECT * FROM stockInfoStatic60 WHERE code ='055550' ORDER BY reg_date DESC LIMIT 5 OFFSET 1;

SELECT SUM(close)/5 AS SUM

FROM (SELECT * FROM stockInfoStatic60 WHERE code ='055550' ORDER BY reg_date DESC LIMIT 5 OFFSET 1);