Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FORCE EDITIONABLE VIEW "IBDC_14"."KLIENT_KOMIKS" ("Nazwisko i imię klienta", "Calkowita kwota zakupów") AS
- SELECT NAZWISKO||' '||IMIE AS "Nazwisko i imię klienta",
- SUM(FAKTURA_NAGLOWEK.WARTOSC_FAKTURY) AS "Calkowita kwota zakupów"
- FROM KLIENT
- INNER JOIN FAKTURA_NAGLOWEK ON KLIENT.ID_KLIENTA = FAKTURA_NAGLOWEK.ID_KLIENTA
- GROUP BY NAZWISKO,IMIE
- ORDER BY 2 DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement