-- drop table LIKES; create table LIKES (NAME varchar(14), FRUITS varchar(14)); insert into LIKES values ('Piglet','apple'); insert into LIKES values ('Piglet','pear'); insert into LIKES values ('Piglet','raspberry'); insert into LIKES values ('Piglet','strawberry'); insert into LIKES values ('Winnie','apple'); insert into LIKES values ('Winnie','pear'); insert into LIKES values ('Winnie','raspberry'); insert into LIKES values ('Kanga','pear'); insert into LIKES values ('Kanga','raspberry'); insert into LIKES values ('Tigger','pear'); insert into LIKES values ('Tigger','raspberry'); insert into LIKES values ('Rabbit','strawberry'); commit; -- grant select on LIKES to public;