GATEverse
← GATE CSE 1998

Q7-a

NATMarks unknown

Suppose we have a database consisting of the following three relations. FREQUENTS (student, parlor)\text{FREQUENTS (student, parlor)} giving the parlors each student visits. SERVES (parlor, ice-cream)\text{SERVES (parlor, ice-cream)} indicating what kind of ice-creams each parlor serves. LIKES (student, ice-cream)\text{LIKES (student, ice-cream)} indicating what ice-creams each student likes. (Assume that each student likes at least one ice-cream and frequents at least one parlor) Express the following in SQL: Print the students that frequent at least one parlor that serves some ice-cream that they like.

Sign in to save attempts.

Loading…