projet-bdd-dvf/todo

SELECT Code_postal, AVG(Valeur_fonciere) FROM DVF2018 WHERE Commune = 'Rennes' AND Code_postal <> ""  GROUP BY Code_postal ORDER BY Code_postal desc;
SELECT Code_departement, ROUND(AVG(Valeur_fonciere)) FROM DVF2018 GROUP BY Code_departement ORDER BY Code_departement asc;