DROP VIEW Affaire;
DROP VIEW Stock;
DROP VIEW Regionale;

CREATE VIEW Regionale AS 
SELECT region.nom as region, client.nom, client.age FROM region JOIN client ON Client.habite = Region.idregion ;

-- Impossible de modifier la vue par contre

CREATE VIEW Stock AS
SELECT * FROM Vin JOIN Article ON Vin.idvin = Article.vin ;

CREATE VIEW Affaire AS
SELECT idvin, MIN(prixht/CAST(contenance AS real)) FROM Stock GROUP BY idvin ;

SELECT Article.idarticle 
FROM Article JOIN Affaire ON Article.vin = Affaire.idvin
WHERE prixht/CAST(contenance AS real) = Affaire.min;