For the following Relational Algebra / SQL statements, specify the output of each query. (do not explain how each query will be executed, but specify the output to be obtained when the query is executed).

(a) R1: ACTORS WHERE YearOfBirth > 1948

C: R1 [ LName ]

(b) SELECT FilmTitle

FROM FILMS

WHERE (LengthInMins BETWEEN 100 AND 200) AND

FilmTitle LIKE '[^ATO]%'

ORDER BY FilmTitle

(c) R1: ACTORS WHERE YearOfBirth

R2(SSNo, FName, LName): R1 [ SSNo, FName, LName ]

R3: R2 NATURAL-JOIN ACTEDIN OVER SSNo

C: R3 [ LName, Character ]

(d) SELECT A1.FName, A1.LName, A1.YearOfBirth

FROM ACTORS A1, ACTORS A2

WHERE A1.YearOfBirth = A2.YearOfBirth AND

A1.SSNo != A2.SSNo

(e) R1: ACTEDIN [ FilmNo, SSNo ]

R2: FILMS WHERE FilmTitle = 'Unforgiven' [ FilmNo ]

R3: ACTEDIN NATURAL-JOIN R2 OVER FilmNo [ SSNo ]

R4: ACTORS NATURAL-JOIN R3 OVER SSNo [ SSNo, FName, LName ]

R5: ( R1.SSNo R4.SSNo ) [ FilmNo ]

C: ACTEDIN NATURAL-JOIN R5 OVER FilmNo [ FilmTitle ]

(f) SELECT A.FName, A.LName, COUNT(*)

FROM ACTORS A, ACTEDIN AI

WHERE A.SSNo = AI.SSNo

GROUP BY A.SSNo, A.FName, A.LName

HAVING count(*) > 2 OR count(*) = 0

I have time limitation please solve it step by step and readable in 1 hour than I will thumbs up you +1

Problem 6 (18 points) Lengthin Mins 107 124 Clint 126 4 131 5 138 6 177 7 202 8 8 229 9 1944 9 131 Jack 151 146 194 2 90 114 Consider the following ACTORS, FILMS and ACTEDIN relations for this problem. ACTORS FILMS SSNO FName LName YearOfBirth Gender Film FilmTitle Yearof Number No Production OfPrices 1 Bruce Willis 1955 male 1 The Sixth Sense 1999 32 2 Milla Jovovich 1975 female 2 Sin City 2005 31 3 Eastwood 1930 male 3 The Fifth Element 1997 9 4 Turkan Soray 1945 female Unforgiven 1992 40 Kevin Costner 1955 male 5 A Perfect World 1993 22 Robert De Niro 1943 male 6 A Bronx Tale 1993 1 7 Yilmaz Guney 1937 male The Godfather 11 1974 16 Pacino 1940 male Once Upon a Time in America 1984 13 Danny Devito male One Flew Over the Cuckoo's Nest 1975 35 10 Nicholson 1937 male 10 The Departed 2006 94 11 Tarik Akan 1949 male 11 The Shining 1980 3 12 Kadir Inanir 1949 male 12 Titanic 1997 121 13 Selvi Boylum Al Yazmalim 1977 ACTEDIN 14 Yol 1982 6 SSNO FilmNo Character 15 Inception 2010 148 1 1 Dr. Malcolm Crowe 1 2 Hartigan 1 3 Korben Dallas 3 Leeloo Bill Munny 5 Chief Red Garnett 13 5 5 Robert Butch' Haynes 6 Lorenzo Vito Corleone 8 David "Noodles' Aaronson Michael Corleone Martini 10 R.P. McMuphy 10 10 Frank Costello 10 11 Jack Torrance 11 14 Seyit Ali 12 13 Ilyas 148 2 3 4 3 Asya 6 6 7 6 8 7 9 9 9