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 ;
bonjour,
pour la réponce n°9
on écrire comme ça!!,
Select Nom, From Reservation R, Client C Where Date_Dep is null And R.Num_Client = C.Num_Client ;