HAVING and sorting

Filtering and sorting go hand in hand and gives you greater interpretability by ordering our results.

Let's see this magic at work by writing a query showing what "countries have the highest average film budgets.

Instructions

Select the country and the average budget as average$\_$budget, rounded to two decimal, from films $.$

Group the results by

Filter the results to countries with an average budget of more than one billion

Sort by descending order of the average$\_$budget $.$