$--8.$ Notice that in this database cities are grouped in "districts" not states. This is because many countries don't have states, they have provinces or some other subdivisions.

Write a report that shows all the cities in the world that start with $"$S$",$ where Spanish is the official language and only list cities that are the capital of its country.

Include the name of the city, the population of the city, the name of the country, the population of the country, the district the city is in$,$ and the official language.

Notice the column in the country table called capital. This is how the database lists the capital of each country so the join between city and country tables will need two conditions. Also remember that the IsOfficial flag in the countrylanguage table is either true, or false, $("$T$"$ or $"$F$")".$ Given database: world Table: city, Country, and countrylanguage.

City columns: ID$,$ Name, Countrycode, District, population

Country Columns: Code, Name, Continent, Region, Surfacearea, IndepYear, population, lifeexpectancy, GNP$,$ GNPold, LocalName, GovernmentForm, HeadofState, Capital, Code$2.$

CountryLanguage columns; Countrycode, language, isofficial, percentage.