--Then using these views write the following queries --4) List the details for the actor that has had the highest number
Posted: Sun Jul 03, 2022 11:24 am
--Then using these views write the following queries--4) List the details for the actor that has had the highest numberof lead roles sorted by actor name descending--5) List the actor details for the actor whose movies combinedhave the lowest overall number of awards--6) List the movie details for any movie that has below theaverage number of awards for movies in its category--7) List the details of any member renting a movie in the categorywith the highest number of movies. Show each member details onlyonce in descending member name order.