SELECT COUNT(waluta) AS ilosc, waluta FROM pozyczka GROUP BY waluta;
SELECT SUM(kwota) AS ilosc, waluta FROM pozyczka GROUP BY waluta;
SELECT MIN(kwota) AS mini, MAX(kwota) AS maxi, waluta FROM pozyczka GROUP BY waluta;
SELECT AVG(kwota) AS ilosc, waluta FROM pozyczka GROUP BY waluta;
SELECT count(id) AS data FROM pozyczka WHERE termin_splaty < "2016-05-01";
SELECT id, klient_id AS Klient FROM pozyczka WHERE kwota = splacono;
SELECT AVG(kwota), waluta FROM pozyczka WHERE termin_splaty < "2016-01-01" GROUP BY waluta;
SELECT COUNT(DISTINCT(waluta)) AS ile FROM pozyczka;
SELECT COUNT(id), waluta FROM pozyczka WHERE kwota > 6000 GROUP BY waluta;
SELECT count(id) AS ile, oprocentowanie from pozyczka GROUP BY oprocentowanie;
SELECT COUNT(*) AS ILEP, klient_id FROM pozyczka GROUP BY klient_id;
SELECT COUNT(*), waluta, oprocentowanie FROM pozyczka GROUP BY oprocentowanie, waluta;
SELECT * FROM pozyczka WHERE WALUTA = "PLN" AND kwota > 5000 OR waluta = "GBP" AND kwota < 4000;
SELECT COUNT(waluta), waluta FROM pozyczka WHERE waluta = "GBP" OR waluta = "PLN" GROUP BY waluta;
SELECT count(waluta), waluta FROM pozyczka WHERE kwota > splacono AND waluta = "EUR" OR waluta = "PLN" GROUP BY waluta;
SELECT AVG(kwota) as SREDNIAPOZYCZEK FROM pozyczka WHERE termin_splaty < "2016-01-01" AND termin_splaty > "2015-01-01";
SELECT * FROM pozyczka ORDER BY kwota ASC, waluta DESC;
SELECT * FROM pozyczka ORDER BY kwota ASC LIMIT 5 OFFSET 14;
SELECT * FROM pozyczka INNER JOIN klient ON klient.id = pozyczka.klient_id WHERE waluta = "GBP";
SELECT max(kwota), waluta FROM pozyczka GROUP BY waluta;
SELECT COUNT(*), monthname(termin_splaty) FROM pozyczka GROUP BY monthname(termin_splaty);
SELECT * FROM pozyczka INNER JOIN klient ON klient.id = pozyczka.klient_id WHERE klient.nazwisko = "Dudek";
SELECT imie, nazwisko FROM klient WHERE (YEAR(NOW()) - YEAR(od_kiedy_konto)) > 5
SELECT imie, nazwisko FROM klient WHERE DATEDIFF(now(), od_kiedy_konto) > 1825;
SELECT klient.imie, klient.nazwisko, waluta, COUNT(*) FROM konto INNER JOIN klient ON konto.klient_id = klient.id GROUP BY nazwisko, waluta;

//25 zadan