Show ids of all students who do not have any friends.
create table highschooler (id varchar, student_id varchar, PRIMARY KEY (id)); create table friend (id varchar, student_id varchar, PRIMARY KEY (id))
select id from highschooler except select student_id from friend