Using the following database schema I need help with the below questions:

Database: moviesfull

Tables:

director

id $($int$,$ primary key, auto$-$increment$)$

dir$\_$firstName $($varchar$(30),$ not null$)$

dir$\_$lastName $($varchar$(30),$ not null$)$

genre

id $($int$,$ primary key, auto$-$increment$)$

gen$\_$title $($varchar$(10),$ not null$)$

rating

rev$\_$id $($int$,$ not null$)$

mov$\_$id $($int$,$ not null$)$

rev$\_$rating $($decimal$(6,1),$ not null$)$

PRIMARY KEY $($rev$\_$id$,$ mov$\_$id$)$

FOREIGN KEY $($mov$\_$id$)$ REFERENCES movie $($id$)$ ON DELETE CASCADE ON UPDATE CASCADE

FOREIGN KEY $($rev$\_$id$)$ REFERENCES reviewer $($id$)$ ON DELETE CASCADE ON UPDATE CASCADE

reviewer

id $($int$,$ primary key, auto$-$increment$)$

rev$\_$name $($varchar$(45),$ default null$)$

movie

id $($int$,$ primary key, auto$-$increment$)$

mov$\_$title $($varchar$(35),$ not null$)$

mov$\_$year $($int$,$ not null$)$

mov$\_$time $($int$,$ not null$)$

mov$\_$lang $($varchar$(15),$ not null$)$

mov$\_$dt$\_$rel $($varchar$(20),$ default null$)$

mov$\_$rel$\_$country $($varchar$(5),$ not null$)$

gen$\_$id $($int$,$ not null$)$

dir$\_$id $($int$,$ not null$)$

FOREIGN KEY $($dir$\_$id$)$ REFERENCES director $($id$)$ ON DELETE CASCADE ON UPDATE CASCADE

FOREIGN KEY $($gen$\_$id$)$ REFERENCES genre $($id$)$ ON DELETE CASCADE ON UPDATE CASCADE

Complete the problems. Use a subquery in each problem.

$1.$ Show the movie genres with an average rating above $5$ for all genres except $1001.($SCREENSHOT$)$

$2.$ Show all movies with more than $10$ ratings and are in a language other than Italian. $($SCREENSHOT$)$

$3.$ Show all movies with an average rating less than $10$ and a release year between $1958-1999.$ Order by year descending. $($SCREENSHOT$)$

PART $2$

Complete the following problems. #$4$ and #$6$ do not require a subquery

$1.$ Show the languages of each movie released before $1965($SCREENSHOT$)$

$2.$ Show all movies with more than $6$ ratings that are in a language different from any movie released before $1965.($SCREENSHOT$)$

Hint: Show all movies with more than $6$ ratings that are in a language Not In the result of your subquery from #$4$

$3.$ Show the reviewers that have a reviewing average over $7\mathrm{.}0($The average of all the ratings they've given is greater than $7)($SCREENSHOT$)$

$$

$4.$ Show all the movies that were rated by reviewers with an average rating greater than $7.($In other words, show all the movies that the reviewers from the previous question have rated$).($SCREENSHOT$)$

Hint: Use the query from #$6$ as a subquery

Complete the following problems using a subquery.

$5.$ Show the movies that have received the highest possible rating.

Hint: The highest possible rating is the maximum rating $($SCREENSHOT$)$

$$

$6.$ Show the movie genres with an average rating above $7$ for genres with at least $4$ movies. $($SCREENSHOT$)$