CREATE VIEW

CREATE OR REPLACE VIEW
V_Reservation (v_nomclient, v_datenaissanecl, v_nomhotel, v_modepay) AS
SELECT C.nomclient, C.datenaissancecl, H.nomhotel, M.modepay
FROM Client C, Hotel H, Modepayment M, Reservation R, Chambre Ch
WHERE
R.numerochambre = Ch.numerochambre
AND
Ch.nomhotel = H.nomhotel
AND
R.codemodepay = M.codemodepay
AND
H.provincehotel = 'Québec'
AND
(C.nomclient LIKE '_a%' OR C.nomclient LIKE '____a%')
AND
C.villecl NOT IN ('Toronto', 'Ottawa')
AND
R.datereservation BETWEEN '2017-02-01' AND '2019-09-30';