I require these queries to be completed in MySQL please :)

The relations are: ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description, release_year, language_id, length, rating, last_update) FILM_ACTOR(actor_id, film_id, last_update) FILM_CATEGORY (film_id, category_id, last_update) COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update) 5. (5 points) Find all the movie titles where and actor called "JOHN OR an actor called "BEN" acted, where there was another actor called "MARY" acting too. (That means movies with JOHN and MARY, movies with BEN and MARY and movies with JOHN, BEN and MARY) 6. (5 points) Find the reviewers that have reviewed movies in all the categories. 7. (5 points) Movies have a length in minutes. Show a list with all the lengths ordered from longer to shorter, and the number of movies for each of the lengths. 8. (5 points) Show the 5 categories with the longer average length (show the name of the category and the average length of the movies for each category) order by average length from longer to shorter and in case of "tie" ordered by category name in alphabetical order. The relations are: ACTOR (actor_id, first_name, last_name, last_update) LANGUAGE (language_id, name, last_update) CATEGORY (category_id, name, last_update) FILM (film_id, title, description, release_year, language_id, length, rating, last_update) FILM_ACTOR(actor_id, film_id, last_update) FILM_CATEGORY (film_id, category_id, last_update) COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update) 5. (5 points) Find all the movie titles where and actor called "JOHN OR an actor called "BEN" acted, where there was another actor called "MARY" acting too. (That means movies with JOHN and MARY, movies with BEN and MARY and movies with JOHN, BEN and MARY) 6. (5 points) Find the reviewers that have reviewed movies in all the categories. 7. (5 points) Movies have a length in minutes. Show a list with all the lengths ordered from longer to shorter, and the number of movies for each of the lengths. 8. (5 points) Show the 5 categories with the longer average length (show the name of the category and the average length of the movies for each category) order by average length from longer to shorter and in case of "tie" ordered by category name in alphabetical order