create table personne (
id integer primary key
generated always as identity
(start with 1, increment by 1), 
nom varchar(50),
date_naissance date, 
service varchar(50));
insert into personne (nom, date_naissance, service)
values('Bob', '1987-10-6', 'Direction');
insert into personne (nom, date_naissance, service)
values('Pierre', '1977-1-6', 'Direction');
insert into personne (nom, date_naissance, service)
values('Fred', '1968-10-9', 'Finances');
insert into personne (nom, date_naissance, service)
values('Frank', '1985-11-8', 'Finances');
insert into personne (nom, date_naissance, service)
values('Julie', '1983-10-6', 'Finances');
insert into personne (nom, date_naissance, service)
values('Christelle', '1987-10-6', 'Finances');