Part 1
Use SQL INSERT statements to populate the database with these five new movies. The Hundred Foot Journey, Lincoln, Raiders of the Lost Ark, Modern Times, Psycho
Part 2
Use SQL SELECT statements to fetch data. Create 5 SQL statements to retrieve data for the following. Create screen shots to show the results of each query execution.
1.In alphabetical order by movie title, list all Stephen Spielberg movies where the star is Tom Hanks.
2.Find all movies where the star is Tom Hanks and group the movies by producer.
3.List all movie titles and producer of the genre “Drama,” group the titles by producer.
4.In alphabetical order by Lead Star, list all movies and group them by genre
5.List all movie titles and the producer where the IMDb Rating is>8.5.
5.List all movie titles and the producer where the IMDb Rating is>8.5.
Part 3
https://www.solvedcollegepapers.com/product/it-234-unit9assignment
https://www.solvedcollegepapers.com/product/it-234-unit-7-assignment
