📊 Analitika i SQL Upiti

SQL:
SELECT r.lokacija, r.kilometraza, r.tezina, COUNT(pr.planinar_id) as broj_planinara, GROUP_CONCAT(CONCAT(p.ime, ' ', p.prezime) SEPARATOR ', ') as planinari FROM rute r LEFT JOIN planinari_rute pr ON r.ruta_id = pr.ruta_id LEFT JOIN planinari p ON pr.planinar_id = p.planinar_id GROUP BY r.ruta_id ORDER BY r.lokacija