PART B. Given the following relational schema Personlpid: integer PRIMARY KEY, name: string, age: integer, liftimelncome: float); Movielmid: integer PRIMARY KEY, title: string, budget: real, yearReleased: integer director: integer REFERENCES Person); appearsla(pid: integer REFERENCES Person, mid: integer REFERENCES Movie, tole: varchar(10), PRIMARY KEY(pid.mid)); role is either 'starring' or 'supporting' In the queries below, an "actor" is a person who has appeared in a movie; and a "director" is a person who was the director of a movie. Write the following queries in SQL (this time you may use aggregates, groupBy, etc.): al. Find the pid of all known actors a2. Find the pid of all known actors and directors. (This is NOT meant to be people who were both actors and directors.) b. Find the name and age of each actor who appeared in both a movie released in 1995 and one released in 2005 c. Find the name of each person whose lifetime income exceeds the budget of all of the movies that he or Find te a e gnt e. Find the id of each person who directed 3 or more movies and controlled the largest total amounts. (The director of a movie is said to control its budget.)