Using Oracle Code Outputs Based Genre Title Find Highest Rent Times Genre Ve Try Order 1 2 Q37107548

I am using oracle

Below is my code and outputs.

How can I based on the genre and title to find the highest renttimes by each genre? I’ve try to order by 1,2,3 and tried usesubqueries, but still failed

Thanks!!

I have to sort genre and title alphabetically first,then sort the rank according to the title

SQL> select genre, title, count (film_id) as RentTimes 2 from film left join inventory using(catalog_num) 3 left join rented_item using(film_id) 4 group by (genre, title) 5 order

OR

 

OR