Shows(Sid, title, synopsis, genre, language, dateOfRelease) Users(login, passwor
ID: 3601648 • Letter: S
Question
Shows(Sid, title, synopsis, genre, language, dateOfRelease)
Users(login, password, country, DOB, name, email)
Review(Rid, dateAndTime, text, rating, Sid, login)
castAndCrew(Pid, name, DOB, placeOfBirth, Sid)
Episodes(Sid, Snum, duration, releaseDate, SeasonNum)
Roles(Pid, roles, character)
ReviewRating(Rid, login, rating)
ShowRating(Sid, login, rating)
ShowTags(Sid, tags)
Movies(Sid, rating, duration)
TVShows(Sid, status, network)
VideoBlogs(Sid, duration)
Review(Sid) references Shows(Sid)
Review(login) references Users(login)
castAndCrew(Sid) references Show(Sid)
Episodes(Sid) references Show(Sid)
Roles(Pid) references castAndCrew(Pid)
Roles(Sid) references Shows(Sid)
ReviewRating(Rid) references Review(Rid)
ReviewRating(login) references Users(login)
ShowRating(Sid) references Shows(Sid)
ShowRating(login) references Users(login)
ShowTags(Sid) references Shows(Sid)
Movies(Sid) references Shows(Sid)
TVShows(Sid) references Shows(Sid)
VideoBlogs(Sid) references Shows(Sid)
i)Which cast members have played multiple roles in shows j) Find all shows in which Emma Watson has played a role. List show title and role name.Explanation / Answer
The above query will return the cast name and their role name who played more than one role.
The above query willl be the show title and role name played by Emma Watson.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.