CREATE OR REPLACE VIEW VUE_JURIDICTION_PAR_VILLE AS
SELECT v.nom_ville, GROUP_CONCAT(t.nom_tribunal SEPARATOR ', ') AS tribunaux
FROM tribunals t
LEFT JOIN villes v ON v.id = t.ville_id
GROUP BY v.nom_ville
ORDER BY v.nom_ville;