Exercice SQL corrigé exprimer des requêtes en SQL

1.  Select Num_Chambre From Chambre Where Confort = ‘TV’ ;

2.  Select Num_Chambre, Nbr_Pers From Chambre ;

3.  Select Sum(Nbr_Pers) From Chambre;

4.  Select Prix/Nbr_Pers, Num_Chambre From Chambre Where Equ = ‘TV’ ;

5.  Select Num_Chambre, Num_Client From Reservation Where Date_Arr <= ’09/02/2004′  And (Date_Dep > ’09/02/2004 OR Date_Dep is Null) ;

6.  Select Num_Chambre From Chambre Where Prix <= OR (Confort=’Bain’ And Prix <=’120′) ;

7.  Select Nom From Client Where Nom Like = ‘D%’ ;

8.  Select Count(Num_Chambre) From Chambre Where Prix between 85 and 120;

9.  Select Nom, From Reservation R,  Client C Where Date_Dep is null And R.Num_Client = C.Num_Client ;