Question

please write a list of sql queries for these exercises

9. For each region of Europe, display its list of countries. Show the region, the name of the country, and the head of state of the country. Sort the results by region and country.

10. Display all of the cities in Brazil, grouped by district. Group the results alphabetically bi district, and the cities within each district alphabetically as well.

Answer 1

1. Query 1

SELECT region, country, state from TABLE
where region = "Europe"
order by region ASC, country ASC

2. Query 2
Select city from TABLE
where country = "Brazil"
group by district
order by district ASC, city ASC

Friend, That was a nice question to answer
If you have any doubts in understanding do let me know in the comment section. I will be happy to help you further.
Thanks