Advertisement
Guest User

Untitled

a guest
Jan 21st, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.26 KB | None | 0 0
  1. SELECT NAZWISKO||' '||IMIE AS "Nazwisko i imię klienta",
  2. SUM(FAKTURA_NAGLOWEK.WARTOSC_FAKTURY) AS "Calkowita kwota zakupów"    
  3. FROM KLIENT
  4. INNER JOIN FAKTURA_NAGLOWEK ON KLIENT.ID_KLIENTA = FAKTURA_NAGLOWEK.ID_KLIENTA
  5. GROUP BY NAZWISKO,IMIE
  6. ORDER BY 2 DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement