Exercise $6\mathrm{.}5$ Practice JOINs $(2$ tables$)$

Purpose: to practice JOINs that require only two tables

MySQL: MoviesFull $(5$ tables$)$

Required Screenshots

$1.$ #$1$

$2.$ #$2$

$3.$ #$3$

$4.$ #$4$

$5.$ #$5$

$6.$ #$6$

$7.$ #$7$

$8.$ #$8$

$9.$ #$9$

$10.$ #$10$

Total Screenshots: $10$

Submit a screen shot for each numbered item.

$1.$ Show all movies that are comedies.

$2.$ Count the number movies in the comedy genre.

$3.$ Show all movies that are made in the $1970$s$.$ Use BETWEEN to determine the year.

$4.$ Show all movies that are: $(1)$ comedies or dramas and $(2)$ released between $1950$ and $1999.$ Use IN to determine genre.

$5.$ Show directors and the number of movies they directed.

$6.$ Show the directors with the number of movies they directed for all directors who have directed more than one movie.

$7.$ Show the movie titles with their average rating, in alphabetical order.

$8.$ Show the movie with the highest average rating.

$9.$ Show the movie with the lowest average rating.

$10.$ Show the reviewers with their average rating, in order by average rating.