SELECT SUM(places_reservees) AS places_reservation FROM Reservation WHERE id_spectacle = 1 ;
SELECT (places_offertes - places_libres) AS places_spectacle FROM Spectacle WHERE id_spectacle = 1 ;
COMMIT ;
