Advertisement
Guest User

Untitled

a guest
Jan 18th, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.47 KB | None | 0 0
  1. SELECT DISTINCT NAZWISKO||' '||IMIE AS "Nazwisko i imię klienta",
  2.      SUM(FAKTURA_DETALE.LICZBA) AS "Suma zakupionych komiksów",
  3.      SUM(DISTINCT FAKTURA_NAGLOWEK.WARTOSC_FAKTURY) AS "Maksymalna kwota zakupów"    
  4.        FROM KLIENT
  5.      INNER JOIN FAKTURA_NAGLOWEK ON KLIENT.ID_KLIENTA = FAKTURA_NAGLOWEK.ID_KLIENTA
  6.      INNER JOIN FAKTURA_DETALE ON FAKTURA_NAGLOWEK.ID_FAKTURY = FAKTURA_DETALE.ID_FAKTURY
  7.      GROUP BY KLIENT.IMIE, KLIENT.NAZWISKO
  8.      ORDER BY 3 DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement