Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement