[BP] popularnost na lokacija za posledni 2 meseci

SELECT
   -- (mom-preth)*100/preth
   momentalen, prethoden, (momentalen-prethoden)*100/prethoden AS procenti
FROM
   (SELECT
      round((SELECT COUNT(*) FROM poseti WHERE EXTRACT(MONTH FROM pos_data) = (SELECT EXTRACT(MONTH FROM sysdate) FROM dual) AND l_id = 4 GROUP BY EXTRACT(MONTH FROM pos_data))/(SELECT COUNT(*) FROM poseti WHERE EXTRACT(MONTH FROM pos_data) = (SELECT EXTRACT(MONTH FROM sysdate) FROM dual)), 2) AS momentalen,
      round((SELECT COUNT(*) FROM poseti WHERE EXTRACT(MONTH FROM pos_data) = (SELECT EXTRACT(MONTH FROM ADD_MONTHS(TO_DATE(sysdate, 'mm/dd/yyyy'), -1)) FROM dual) AND l_id = 4 GROUP BY EXTRACT(MONTH FROM pos_data))/
(SELECT COUNT(*) FROM poseti WHERE EXTRACT(MONTH FROM pos_data) = (SELECT EXTRACT(MONTH FROM ADD_MONTHS(TO_DATE(sysdate, 'mm/dd/yyyy'), -1)) FROM dual) GROUP BY EXTRACT(MONTH FROM pos_data)), 2) AS prethoden
   FROM dual)