3 tables. Movie(id, title,year,rating ,company); Actor(id, lastname,firstname,se

Question

3 tables. Movie(id, title,year,rating ,company); Actor(id, lastname,firstname,sex,dateofbirth, dateofdeath); MovieActor(movieid, actorid, role); #1 write SQL statements that give the name of all the actors in the movie 'Die another day' #2 write SQL statements that give the count of all the actors who acted in multiple movies. #3 write SQL statements that give the name of all the movies Chris Tucker acted in. The tables are created and loaded. What I wrote solves the questions but run very slow. Please give a solution that will run fast. will give lifesaver.

Explanation / Answer

Movie Die another day, IMBd ratting 6%, year 2002,

Actor first name(Pierce), last name(Brosnan), (born 16 May 1953), alive

1)SELECT lastname,firstname FROM Actor WHERE movie = 'Die another day'

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.