Please use Pagilla database to solve it

Q3: List the most rented movie names with rental counts for each country. If the movies have same rental counts for the country, you can display one of them. Use a single query for this question (you can use nested queries but can not use views, functions etc.) Your answer Requested query Q3 returns (some parts only) like below: Data Output Explain Messages Notifications country text title text rental_count bigint 1 India WIFE TURN 9 2 China STORY SIDE 8 3 Mexico WITCHES PANIC 6 4 United States SLEUTH ORIENT 6 5 Japan NEWTON LABYRINTH 5 6 Russian Federation ROSES TREASURE 5 7 Brazil ROCKETEER MOTHER 5 8 Argentina ROMAN PUNK 4