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 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.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
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.
Transcribed Image Text: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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education