:: Tutorial $8-$ Additional SQL exercises

With reference to the Video$-$Rental database, find the results for the following using SQL$.$

What is the average movie rental fee for Drama movies?

$,$ Ans $=2\mathrm{.}83$

What is the name of the most expensive movie?

Ans $=$ Constant Companion at $$89\mathrm{.}95$

List the name, number and cost of the oldest movie.

$,$ Ans $=1239$ Where Hope Dies at $$25\mathrm{.}49$

List the number of videos per movie.

$,$ Ans $=$

What is the total value of all videos in the database?

$,$ Ans $=$$$802\mathrm{.}45$