Database
Employés Médiathèque Immeubles Livraisons Entreprise Université Buildings (English) Company (English) Deliveries (English) Employees (English)

Tables

Write a SQL query

Table Departments

idD	Name	City
1	Management	Reims
2	Communications	Reims
3	Marketing	Paris
4	Production	Lille
5	Accounting	Paris
6	Accounting	Reims
7	Production	Paris