Question: Implement the following queries using SQL. (a) retrieve all the character names being acted in the film The Godfather II. (b) find all the actors

Implement the following queries using SQL.
(a) retrieve all the character names being acted in the film The Godfather II.
(b) find all the actors who had acted in more than two(2) films. For each such actor, retrieve his/her First Name, Last Name, and the number of films (s)he had acted in.
(c) retrieve the total number of prices the films had received in which the actor Robert De Niro acted.
Consider the following ACTORS, FILMS and ACTEDIN relations for this problem. The Primary Keys of the relations are underlined. Foreign Key Constraints are represented by arrows. ACTORS ( SSNo, FName, LName, YearOfBirth, Gender) FILMS ( FilmNo, FilmTitle, YearOfProduction, NumberOfPrices, Lengthin Mins) ACTEDIN ( SSNo, FilmNo, Character )
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
