or guestaddress like urb 5 los literales a y b tienen

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: de los hoteles de Londres. e) Muestre toda la información de reservas que no tengan fecha definida de salida. f) Muestre toda la información de las habitaciones con precio inferior a los $40 que sean de tipo doble o sencilla (tipo ‘D’ o ‘S’). g) SELECT hotelNo, roomNo, price FROM Room WHERE type IN (‘M’, ‘D’, ‘T’) AND (price BETWEEN 80 AND 120) ORDER BY price DESC h) SELECT guestName, guestAddress FROM Guest WHERE guestName LIKE ‘%[iu]’ AND (guestAddress LIKE ‘%Cdla.%’ OR guestAddress LIKE ‘%Urb.%’) 5) Los literales a) y b) tienen un valor de 2...
View Full Document

This document was uploaded on 02/11/2014.

Ask a homework question - tutors are online