a) SELECT nom
partie.dateJouee BETWEEN. to_date('2004-09-01','YYYY-MM-DD') AND. to_date
('2005-06-30 23:59:59','YYYY-MM-DD HH24:MI:SS'). GROUP BY nom, ville.
partie.dateJouee BETWEEN. to_date('2004-09-01','YYYY-MM-DD') AND. to_date
('2005-06-30 23:59:59','YYYY-MM-DD HH24:MI:SS'). GROUP BY nom, ville.