Dada la tabla HAB_ROOM(planta_floor,num,tipo_type) siendo su primary key planta_...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Dada la tabla HAB_ROOM(planta_floor,num,tipo_type) siendo su primary key planta_floor y num con num el número de habitación. Escribe una consulta que devuelva el número de habitación mayor y menor por planta_floor, con el orden de los atributos devueltos planta_floor, maximo y mínimo.Given HAB_ROOM(planta_floor,num,tipo_type) with its primary key being planta_floor and num with num being the room number. Write a statement that returns the lower and upper room number for each planta_floor. The order of the attributed selected must be: planta_floor, maximum, minimum.
Want instant access to all verified answers on campusvirtual.uclm.es?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!