Menu ▾ ▴

[35b350]: / Sample Query 2.sql  Maximize  Restore  History

Download this file

5 lines (5 with data), 228 Bytes 

1
2
3
4
5
/*List the services that the hotel "Eu Augue Limited" have*/ 

select ServiceName,Serv_Type from services, serho

where services.ServiceID=serho.ServiceID

and HotelID=(select HotelID from hotels

where HotelName="Eu Augue Limited")