$2\mathrm{.}1-2\mathrm{.}4$ are based on the following schema:

Movie $($ID$,$ Title, Genre, RatingCode, Year$)$

Rating $($Code$,$ Description$)$

$2\mathrm{.}1$ List all romantic $($Genre$)$ movies.

$2\mathrm{.}2$ List all years and the total number of movies for that year.

$2\mathrm{.}3$ List all movies and code descriptions for the year $2021.$

$2\mathrm{.}4$ List all R$-$rated $($RaringCode$)$ movies released in $2021$ but not the movie 'Candyman$2\mathrm{.}1-2\mathrm{.}4$ are dasod on the lollowning senema:

Movie $($ID$,$ Title, Genre, BailinsCode, Year$)$

Rating $($Code$,$ Description$)$

$2\mathrm{.}1$ Wit all romantic $($Genre$)$ movies.

$2\mathrm{.}2$ List all years and the cotal number of movles for that year.

$2\mathrm{.}3$ List all movies and code doseriptions for the year $2021.$

$2\mathrm{.}4$ List all R$-$rated $($RapingCode$)$ movies released in $2021$ bus not the movie 'Candyman'.

$2\mathrm{.}5-2\mathrm{.}8$ are based on Question $1\text{'}$s schema.

$2\mathrm{.}5$ Find the make and model of the most expensive printer,

$2\mathrm{.}6$ Find the average price of FCs by each maker.

$2\mathrm{.}7$ Find the average price of PCs manufactured by makor "WISEBI".

$2\mathrm{.}8$ Find the maker of PCs with at leare three different ram alze.