Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT g.tytuł || ' [' || p.nazwa || ']' AS title, TO_CHAR(g.data_produkcji,'yyyy') ||', '|| g.producent ||', '|| k.nazwa AS more_info, COUNT(*) AS purshase_count ,MAX(z.data_zamówienia) AS last_purchase_date, AVG(o.ocena) AS avg_opinion, listagg(o.opis, ', ') within GROUP (ORDER BY o.ocena DESC) AS opinions FROM ZamowieniaGry zg
- join Zamówienia z ON z.id_zamówienia = zg.id_zamowienia
- join Gry g ON g.id_gry = zg.id_gry
- join platformy p ON p.id_platformy = g.id_platformy
- join Kategorie k ON k.id_kategorii = g.id_kategorii
- join Klienci kl ON kl.id_klienta = z.id_klienta
- join opinie o ON o.id_zamówienia = z.id_zamówienia GROUP BY g.tytuł || ' [' || p.nazwa || ']', TO_CHAR(g.data_produkcji,'yyyy') ||', '|| g.producent ||', '|| k.nazwa
- ORDER BY title AS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement