Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select id_cine as Cinema ,
- CA_par_cine / CA3meilleurs * 600 AS PrimeDuDirecteur,
- CA_par_cine AS sonCA
- FROM (
- SELECT
- id_cine,
- sum(nb_places_vendues_reduit * tarif_reduit + nb_places_vendues_plein *
- tarif_plein) AS CA_par_cine
- FROM projeter P ,salles S
- WHERE P.id_salle = S.id_salle
- GROUP BY 1
- LIMIT 3 ) LesCaParCine
- ,
- (
- SELECT sum(CA_par_cine) CA3meilleurs
- from ( select sum(nb_places_vendues_reduit * tarif_reduit +
- nb_places_vendues_plein * tarif_plein) AS CA_par_cine
- FROM projeter P2 ,salles S2
- WHERE P2.id_salle = S2.id_salle
- GROUP BY S2.id_cine
- LIMIT 3 ) Les3MeilleursCine
- ) CAcumuleDes3MeilleursCine
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement