delete from likes;


insert into likes (login_name, mtitle) values ('anca', 'Armageddon');
insert into likes (login_name, mtitle) values ('bob', 'Armageddon');
insert into likes (login_name, mtitle) values ('bob', 'TRON');
insert into likes (login_name, mtitle) values ('charlie', 'Armageddon');
insert into likes (login_name, mtitle) values ('charlie', 'TRON');
insert into likes (login_name, mtitle) values ('charlie', 'Bolt');


drop view  if exists liked;
drop view  if exists all_charlie;
drop view  if exists all_comb;
drop view  if exists nonexst;

create view liked as select mtitle from (select mtitle from likes where login_name='charlie') as charlie_liked;
create view all_comb as select login_name, mtitle from all_charlie, movies;
create view nonexst as select login_name, mtitle  from all_comb except (select login_name, mtitle from likes);

select count(*) from likes;
select mtitle from nonexst;


