Topic: MySQL IMDB SQL Queries

Please use the attached MySQL DB (imdb.zip) and come out with the SQL statements and results for the following 10 questions: 1. Find how many actors are stored in the actors table. 2. Find all information for actor with id 376249. 3. Find all the actors that played in the movie Ocean's Twelve. 4. Find all the movies that have the word "Vietnam" in their title. 5. Find the number of movies that each actor has played. Show just the actor id and the number of movies. 6. Find the number of actors for each movie. Show just the movie id and the number of actors in the movie. 7. Find the time period in which each actor was active, by listing the earliest and the latest year in which the actor starred in a film. 8. Repeat the query above, but only list actors that have starred in at least 10 movies. 9. Find the director that has directed the largest number of movies. 10. List the director that worked with the largest number of actors

SophiaPretty

(5)

Status NEW Posted 20 Nov 2017 01:11 PM My Price 6.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer