help with sql query using moviesfull database

1.Show movies with their average rating in increasing order

2. Show all reviewers with their average rating in increasing order.

3. Repeat the query above, but this time show only average ratings where reviewer name is empty

4. Show the movie with its highest rating in descending order

5. Show movie title, reviewer, director, and rating in ascending order by movie

6. Show directors with their average movie rating in alpha order by director

7. Show the director with the highest average rating

8. Which directors have movies in multiple genres?

9. Which reviewer gives the highest average ratings?

10. Show the reviewer's name with the number of ratings for the reviewer with the least number of ratings

MySQL Workbench X Local instance MySQL80 x File Edit View Query Database Server Tools Scripting Help Navigator SQL File 3" SCHEMAS 17 5 208 Limit to 1000 rows . | 1 7 Q Filter objects 1 . SELECT movie_title, AVG(rating) AS average_rating employee 2 FROM movies moviesbasic W JOIN ratings ON movies.movie_id = ratings.movie_id music_basic 4 shingara_trees GROUP BY movies. movie_id, movie_title shingaramoviesfull ORDER BY average_rating; 7Tables director genre movie rating reviewer Views Stored Procedures Functions sys Administration Schemas Information MMMMMMMMMMMM868 No object selected Action Output Duration Time Action Message / Fetch 1 17:36:29 SELECT movie_title. AVG(rating) AS average_rating FROM movies JOIN ratings ON movies.movie_jd = ratings.movie... Error Code: 1146. Table 'shingaramoviesfull.movies' doesn't exist 0.000 sec X Object Info Session