--1
SELECT SUM(`places`) AS 'nb_places' , `etage_salle`
FROM `salles`
GROUP BY `etage_salle`;


--2
SELECT UPPER(`titre`)
FROM `films`
WHERE id_genre='17';


--3
SELECT `films`.titre , `genres`.nom
FROM `films`
JOIN `genres` ON `films`.`id_genre`=`genres`.`id_genre`
LIMIT 0,10;


--4
SELECT `films`.`titre` , `genres`.`nom` AS 'genres', `distributeurs`.`nom` AS 'distributeurs'
FROM `films`
JOIN `genres` ON `films`.`id_genre`=`genres`.`id_genre`
JOIN `distributeurs` ON `films`.`id_distributeur`=`distributeurs`.`id_distributeur`
WHERE `id_film` BETWEEN 3540 AND 3555;


--5
SELECT `personnes`.`nom` , `personnes`.`prenom` , `personnes`.`email`
FROM `personnes`
JOIN `employes` ON `personnes`.`id_personne`=`employes`.`id_personne`
WHERE `id_fonction` = '1';


--6
UPDATE `personnes`
SET `adresse` ='22 rue du labrador'
WHERE `id_personne` ='18';


--7
INSERT INTO `forfaits` (`nom`,`prix`,`resum`,`duree_jours`)
VALUES ('supinternet','78','Reservé aux etudiants de SUP''Internet','365');


--8
UPDATE `personnes`
SET
`nom` = 'AIHONNOU',
`prenom` = 'Olivier',
`date_naissance` = '1994-05-11',
`email` = 'olivier.aihonnou@supitnernet.fr',
`adresse` = '32/42 RUE Raymond Marcheron',
`cpostal` = '92170',
`ville` = 'Vanves',
`pays` = 'France'
WHERE `id_personne` ='83';


--9
DELETE FROM `personnes`
WHERE `id_personne` IN (SELECT  `id_personne` FROM `employes` WHERE `id_fonction` = '5');