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$)$