--ZAD4
CREATE OR REPLACE VIEW wplaty_wyplaty(Konto, "Ilosc wyplat", "Ilosc wplat") AS
SELECT nr_konta,
COUNT(CASE WHEN nr_konta = z_konta THEN 1 END),
COUNT(CASE WHEN nr_konta = na_konto THEN 1 END)
FROM konta CROSS JOIN transakcje
GROUP BY nr_konta
ORDER BY 1,2,3;
----