[BP] poseti na lokacija za momentalen i prethoden mesec

SELECT
   momentalen, prethoden
FROM
   (SELECT (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)) AS momentalen,
   (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)) AS prethoden FROM dual)