Advanced SQL queries. Write the appropriate query given this schema:

(each query will use at least one SELECT statement)

List the titles of movies that cast the actor Kevin Bacon.

List the names of actors, if any, that were cast in any movie that has votes between 3000 and 4000.

List the titles of movies that have a higher score than some movie in the database.

List the titles of movies that have the highest score in the database.

Find the IDs of actors who were cast in more than one movie.

List the titles of movies that have a cast of more than 5 actors.

For each year, list the title of the movie with the most votes.

List the titles of both the movie with the highest score and the movie with the second highest score.

List the names of actors, if any, that were cast in all the movies that have votes between 3000 and 4000.

From among the actors that have appeared in more than ten movies, list their name and the average score of all the movies they were cast in

Movie (MoviclD, Title, Year, Score, Votes) Actor(ActorlD, Name) Casting (MoviclD, ActorlD, Ordinal)