New to SQL. Hope to find distinct pizza sold by restaurants that are located in the same area as bob (customer).
SELECT distnct pizza FROM Sells WHERE rname in ( SELECT rname FROM Restaurants WHERE area..... -- This is the part where i don't know how to continue. -- How do i write it so that i compare the location of the restaurant with bob's location? );