Return to exercises

Show how many families live in each place. Children are assumed to live with one of their parents and parents are assumed to live together if they share a child and are in the same city.

SQL:

Tables:

cities

id	City
2	Eindhoven
1	Tilburg
3	Veldhoven
4	Den Bosch

parentchild

Child	Father	Mother
6	1	3
7	1	3
8	4	5

people

Id	Name	DOB	City
1	Marcel	0000-00-00	1
2	Peter	0000-00-00	2
3	Gitte	0000-00-00	1
4	Leon	0000-00-00	2
5	Inge	0000-00-00	3
6	Sienna	1990-01-01	1
7	Thomas	1992-01-01	1
8	Bas	1994-01-01	2