sql query

Given the following tables, write a query to display all people who do not like the bears.

create table PEOPLE (
   NAME varchar(20),
   primary key NAME
);
create table TEAM_LIKES (
   NAME varchar(20),
   LIKES varchar(20),
   foreign key NAME references PEOPLE (NAME)
);

Answer:
select distinct PEOPLE.NAME from PEOPLE where PEOPLE.NAME not in (select
NAME from TEAM_LIKES where LIKES='bears');