Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT NAZWISKO||' '||IMIE AS "Nazwisko i imię klienta",
- SUM(FAKTURA_DETALE.LICZBA) AS "Suma zakupionych komiksów",
- SUM(DISTINCT FAKTURA_NAGLOWEK.WARTOSC_FAKTURY) AS "Maksymalna kwota zakupów"
- FROM KLIENT
- INNER JOIN FAKTURA_NAGLOWEK ON KLIENT.ID_KLIENTA = FAKTURA_NAGLOWEK.ID_KLIENTA
- INNER JOIN FAKTURA_DETALE ON FAKTURA_NAGLOWEK.ID_FAKTURY = FAKTURA_DETALE.ID_FAKTURY
- GROUP BY KLIENT.IMIE, KLIENT.NAZWISKO
- ORDER BY 3 DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement