--Vjezba 2
USE AdventureWorksOBP

CREATE OR ALTER VIEW vKreditnaKartice AS
SELECT * FROM KreditnaKartice as kk
WHERE kk.Tip 'American Express' OR kk.Tip 'MasterCard'
-- kk.Tip IN ('Visa','MasterCard')
WITH CHECK OPTION

INSERT INTO vKreditnaKartice (Tip, Broj, IstekMjesec, IstekGodina)
values ('American Express', '1112323', 12, 2024)

INSERT INTO vKreditnaKartice (Tip, Broj, IstekMjesec, IstekGodina)
values ('MasterCard', '125451324', 8, 2024)

INSERT INTO vKreditnaKartice (Tip, Broj, IstekMjesec, IstekGodina)
values ('Erste', '1233155', 4, 2024)

DROP TABLE vKreditnaKartice