Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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