Film producers want to show the work of analysts. They do not always do it well. Sometimes it ends in a strange mix of mathematics and supernatural skills that gives the people working with data a headache. In no order, here is my selection of the best Hollywood and independent films featuring data analysis. USE the tables of the database Holly_Movies to answer SQL related questions below. NB: You do not need to create the database. If you join too many tables together that are not needed for the query, you will not receive full marks. Some information is not captured in the tables below. You may need to assume that your database has all the records. NB: You should solve this problem using the SQL syntax only. Write an SQL query on the Holly_Movies database to answer the following questions and ensure that all SQL returned results are in alphabetical order where necessary. Use SQL queries to search for the names and years of all movies that had at least 2 directors, one of whom was Michael Jackson, where Michael has also acted in the movie.
Film producers want to show the work of analysts. They do not always do it well.
Sometimes it ends in a strange mix of mathematics and supernatural skills that gives
the people working with data a headache. In no order, here is my selection of the best
Hollywood and independent films featuring data analysis. USE the tables of the
NB: You do not need to create the database. If you join too many tables together that
are not needed for the query, you will not receive full marks. Some information is not
captured in the tables below. You may need to assume that your database has all the
records.
NB: You should solve this problem using the SQL syntax only. Write an SQL query on the
Holly_Movies database to answer the following questions and ensure that all SQL returned
results are in alphabetical order where necessary.
Use SQL queries to search for the names and years of all movies that had at least 2
directors, one of whom was Michael Jackson, where Michael has also acted in the
movie.
![actors
movies
roles
actor_id movie_id
first_name last_ name gender
уear rank
1999 8.5
209658 Meet the Parents 2000 7
2000 8.7
id
id
name
role
433259 William
Shatner
M
112290 Fight Chub
433259
313398
Capt. James T. Kirk
797926 imey
Spears
407323
Sgt. TJ. Hooker
433259
831289 Sigourney
Weaver
F
210511 Memento
926ז9ר
342189
Herself
movies directors
director_id movie_id
112290
directors
movies_genres
id
first_name
last name
movie_id
genre
24758 David
Fincher
24758
209658
Comedy
66965
Jay
Roach
66965
209658
313398
Action
72723
William
Shatner
72723
313398
313398
Sc-Fi](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F226f8c99-9a09-4cfc-a7ea-0c72da1eacaa%2Fac701e8b-3444-411a-8535-d48e940a90d0%2Fru3xao9_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)