Related Articles

Related Articles

Aptitude | GATE CS 1998 | Question 62
  • Last Updated : 12 Oct, 2017

Suppose we have a database consisting of the following three relations.

FREQUENTS(student, parlor) giving the parlors each student visits.
SERVES(parlor, ice-cream) indicating what kind of ice-creams each parlor serves.
LIKES(student, ice-cream) indicating what ice-creams each parlor serves.

(Assuming 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.



Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :