Consulta9.sql

Oracle 11 |

0 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

SELECT nombre
FROM
(SELECT COUNT(*) AS NUMEROAPERITIVOS, ID_BAR
FROM
(SELECT *
FROM
(SELECT B.ID , B.Nombre AS NombreBebida, T.Nombre AS NombreTipo  FROM (Parranderos.BEBIDAS B INNER JOIN Parranderos.TIPO_BEBIDA T ON B.ID=T.ID)) Tipos INNER JOIN PARRANDEROS.sirven S  ON Tipos.ID=S.ID_BEBIDA)Toda
WHERE Toda.HORARIO = 'diurno' AND Toda.NOMBRETIPO='aperitivo'
GROUP BY Toda.ID_BAR)num_aperitivos
INNER JOIN Parranderos.Bares X ON num_aperitivos.ID_BAR =X.ID
WHERE PRESUPUESTO='Alto' AND NUMEROAPERITIVOS BETWEEN 3 AND 7
ORDER BY numeroaperitivos, nombre

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Consulta9.sql

Comments