SELECT * FROM CLIENTE1 WHERE NOMBRE = 'Victor';

SELECT * FROM CLIENTE1 WHERE NOMBRE LIKE 'C%';

SELECT * FROM CLIENTE1 WHERE ID_CLIENTE1 BETWEEN 1 and 20;

SELECT * FROM VENDEDOR1;

SELECT * FROM HABITACION WHERE NUMERO_CAMAS = 3;

SELECT * FROM HABITACION WHERE (ID_TIPO = 1) and (NUMERO_CAMAS in('1','2'));

SELECT * FROM HABITACION ORDER BY NUMERO_CAMAS ASC;

SELECT ID_TIPO, COUNT(*) FROM HABITACION GROUP BY ID_TIPO;

SELECT T.NOMBRE, H.ID_TIPO, COUNT(*) FROM "TIPO" T, "HABITACION" H WHERE T.ID_TIPO = H.ID_TIPO GROUP BY H.ID_TIPO;

SELECT * FROM ALQUILER WHERE PRECIO BETWEEN 3000 and 5000;

SELECT * FROM "ALQUILER" A WHERE EXISTS (SELECT * FROM "HABITACION" H WHERE ID_HABITACION=A.ID_HABITACION AND H.ID_TIPO='1');

SELECT A.ID_CLIENTE1, A.PRECIO, C.NOMBRE FROM "ALQUILER" A, "CLIENTE1" C WHERE A.ID_CLIENTE1=C.ID_CLIENTE1 and A.ID_VENDEDOR1=5;