Purpose: to practice the basics of subqueries

MySQL Requirements: moviesFull database

zyBooks: $3\mathrm{.}63\mathrm{.}7$

Required Screenshots

$1.$ Section: PART $1$ Step #$1$

$2.$ Section: PART $1$ Step #$2$

$3.$ Section: PART $1$ Step #$3$

$4.$ Section: PART $2$ Step #$1$

$5.$ Section: PART $2$ Step #$2$

$6.$ Section: PART $2$ Step #$3$

$7.$ Section: PART $2$ Step #$4$

$8.$ Section: PART $2$ Step #$5$

$9.$ Section: PART $2$ Step #$6$

Total Screenshots: $9$

PART $1$

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

$2$

$3.$ Show all movies with an average rating less than $10$ and a release year between $1958-$

$1999.$ Order by year descending. $($SCREENSHOT$)$

$3$

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$

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