Nacitavam...
Posledne duely
| Datum | Superik 1 | Superik 2 | Vitaz | Miesto | Trvanie |
|---|---|---|---|---|---|
| Nacitavam... | |||||
Zoznam carodejnikov
| Priezvisko | Meno | Fakulta | Prutik | Uroven | Vyhry | Duely |
|---|---|---|---|---|---|---|
| Nacitavam... | ||||||
Register duelov
| Datum | Superik 1 | Superik 2 | Vitaz | Miesto | Trvanie (min) |
|---|---|---|---|---|---|
| Nacitavam... | |||||
Katalog kuziel
| Nazov kuzla | Kategoria | Nebezpecnost | Zakazane |
|---|---|---|---|
| Nacitavam... | |||
Rebricek carodejnikov
| # | Meno a priezvisko | Fakulta | Vyhry | Prehry | Duely | Uspesnost |
|---|---|---|---|---|---|---|
| Nacitavam... | ||||||
Evidencia zakazanych kliatob
* * *
| Kliatba | Dovod zakazu | Rok zakazu | Nebezpecnost |
|---|---|---|---|
| Nacitavam... | |||
Zaznamy o poruseniach
| Carodejnik | Kliatba | Datum | Sankcia |
|---|---|---|---|
| Nacitavam... | |||
Povinne SQL dotazy
Dotaz I - 10 carodejnikov s najvyssim poctom vyhier (zoradene abecedne pri zhode)
SELECT c.meno, c.priezvisko, f.nazov AS fakulta, s.vyhry
FROM statistika s
JOIN carodejnik c ON s.id_carodejnik = c.id_carodejnik
JOIN fakulta f ON c.id_fakulta = f.id_fakulta
ORDER BY s.vyhry DESC, c.priezvisko ASC
LIMIT 10;
FROM statistika s
JOIN carodejnik c ON s.id_carodejnik = c.id_carodejnik
JOIN fakulta f ON c.id_fakulta = f.id_fakulta
ORDER BY s.vyhry DESC, c.priezvisko ASC
LIMIT 10;
| # | Meno | Priezvisko | Fakulta | Vyhry |
|---|---|---|---|---|
| Nacitavam... | ||||
Dotaz II - Najcastejsie pouzivane kuzla v dueloch (zoradene zostupne)
SELECT tk.nazov, tk.kategoria, COUNT(pk.id_pouzitie) AS pocet_pouziti
FROM pouzite_kuzlo pk
JOIN typ_kuzla tk ON pk.id_typ_kuzla = tk.id_typ_kuzla
GROUP BY tk.id_typ_kuzla, tk.nazov, tk.kategoria
ORDER BY pocet_pouziti DESC;
FROM pouzite_kuzlo pk
JOIN typ_kuzla tk ON pk.id_typ_kuzla = tk.id_typ_kuzla
GROUP BY tk.id_typ_kuzla, tk.nazov, tk.kategoria
ORDER BY pocet_pouziti DESC;
| # | Kuzlo | Kategoria | Pocet pouziti |
|---|---|---|---|
| Nacitavam... | |||
Dotaz III - Fakulty s najlepsimi duelantmi (JOIN, GROUP BY, ORDER BY)
SELECT f.nazov AS fakulta, COUNT(d.id_vitaz) AS pocet_vyhier,
COUNT(DISTINCT c.id_carodejnik) AS pocet_carodejnikov
FROM fakulta f
JOIN carodejnik c ON c.id_fakulta = f.id_fakulta
JOIN duel d ON d.id_vitaz = c.id_carodejnik
GROUP BY f.id_fakulta, f.nazov
ORDER BY pocet_vyhier DESC;
COUNT(DISTINCT c.id_carodejnik) AS pocet_carodejnikov
FROM fakulta f
JOIN carodejnik c ON c.id_fakulta = f.id_fakulta
JOIN duel d ON d.id_vitaz = c.id_carodejnik
GROUP BY f.id_fakulta, f.nazov
ORDER BY pocet_vyhier DESC;
| Fakulta | Pocet vitazstiev | Pocet carodejnikov |
|---|---|---|
| Nacitavam... | ||