Reference no: EM132255288
Suppose you are given the database schema
eecs3421country(code, name, continent, region, surfacearea, indepyear, population, lifeexpectancy, gnp, gnpold, localname, governmentform, headofstate, capital, code2)
eecs3421city(id, name, countrycode, district, population)
eecs3421countrylanguage(countrycode, countrylanguage, isofficial, percentage)
...where continent = {Asia, Europe, North America, South America, Africa, Oceania, Antarctica}
and the question is
What is the second most popular language spoken in Italy?.
What query should you use to get the right answer, using PostgreSQL?