Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT NVL(TO_CHAR(SALON.NAZWA), ' ') AS "SALON",
- NVL(TO_CHAR(TYP_USLUGI.NAZWA), ' ') AS "USLUGA",
- COUNT(USLUGA.KLIENT_ID_FK) AS "LICZBA KLIENTOW",
- TO_CHAR(SUM(USLUGA.CENA)) || ' ZŁ' AS "PRZYCHOD CALOSCIOWY"
- FROM USLUGA, TYP_USLUGI, SALON, ROK, KWARTAL, MIESIAC, DZIEN
- WHERE USLUGA.DZIEN_ID_FK=DZIEN.DZIEN_ID AND
- DZIEN.MIESIAC_ID_FK=MIESIAC.MIESIAC_ID AND
- MIESIAC.KWARTAL_ID_FK=KWARTAL.KWARTAL_ID AND
- KWARTAL.ROK_ID_FK=ROK.ROK_ID AND
- ROK.WARTOSC BETWEEN 2015 AND 2018 AND
- USLUGA.TYP_USLUGI_ID_FK=TYP_USLUGI.TYP_USLUGI_ID AND
- USLUGA.SALON_ID_FK=SALON.SALON_ID
- GROUP BY CUBE(SALON.NAZWA, TYP_USLUGI.NAZWA)
- ORDER BY SALON.NAZWA DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement