Show the ids of high schoolers who have friends and are also liked by someone else.
create table likes (student_id varchar, liked_id varchar, PRIMARY KEY (student_id)); create table friend (student_id varchar, liked_id varchar, PRIMARY KEY (student_id))
select student_id from friend intersect select liked_id from likes