UPDATE Spectacle SET places_offertes = places_offertes + 10, places_libres = places_libres + 10 WHERE id_spectacle = 1 ;
UPDATE Reservation SET places_reservees = places_reservees + 10 WHERE id_client = 2 AND id_spectacle = 1 ;
COMMIT ;
