Подсчет выручки : Супермаг Плюс (Супермаг 2000)

SELECT createdat "дата", sum(decode(doctype,'CS',totalsum,'CR',-totalsum,0)) "выручка"
FROM smdocuments
WHERE doctype in ('CR','CS')
AND createdat BETWEEN SYSDATE - 120 AND SYSDATE
GROUP BY createdat
ORDER BY 1

select * from (SELECT "магазин", sum("выручка")
FROM (SELECT (SELECT NAME
FROM smstorelocations
WHERE ID =
DECODE (doctype,
'CS', locationfrom,
'CR', locationto,
0
)) "магазин",
(DECODE (doctype, 'CS', totalsum, 'CR', -totalsum, 0)
) "выручка"
FROM smdocuments
WHERE doctype IN ('CR', 'CS')
AND createdat BETWEEN TRUNC (SYSDATE, 'MONTH') AND SYSDATE)
GROUP BY "магазин"
ORDER BY 2 DESC) where rownum<11