-- corr_ind2.sql
-- 20 mars 2019

select * from village;
select * from sejour;

drop view vue_village_sans_sejour;
create view vue_village_sans_sejour as
    select idv, ville, activite, prix
        from village
        where idv not in (select idv
                          from sejour);

select * from village;
select * from sejour;
select * from vue_village_sans_sejour;

insert into sejour values(102, 1, 10, 1);

insert into village values(13, 'Amiens', 'MOMA', 100, 20);

select * from village;
select * from sejour;
select * from vue_village_sans_sejour;

delete sejour
    where jour < 50;

select * from village;
select * from sejour;
select * from vue_village_sans_sejour;

--------------------------------------------------------------------------------
