Hi Everyone I need the answer for these three questions by writing the sql state

Question

Hi Everyone

I need the answer for these three questions by writing the sql statement for them as soon as possible

I need to be able to copy it. So, please do not put the answer as a picture

1- list the names of nobel winners in the economics in the last 30 years

(n.b: the name of the table is nobel and contains 3 columns. the columns are year, subject, and winner)

2- list all the contries that are larger and richer than Maxico

(n.b: the name of the table is world and contains 5 columns. the columns are name, continent, area, population, gdp

3- give the query for the total population of all the spanish speaking countries in South America.

(n.b: the name of the table is world and contains 5 columns. the columns are name, continent, area, population, gdp

Explanation / Answer

1.

SELECT winner
FROM nobel
WHERE subject = 'Economics' AND Year between 2016 AND 1986

or

SELECT winner
FROM nobel
WHERE subject = 'Economics' AND Year >= 1986

2.

SELECT name
FROM world
WHERE Area > 'Maxico' AND gdp/population > ( SELECT gdp/population
                                                                              FROM world
                                                                              WHERE name = 'Maxico'      
                                                                               )  

3. Some more information required ( like language column to fetch result ) as the tables mentioned in this are same   as of Qus 2

Based on the information availabe , it could be like

Select SUM ( population) FROM World
where continent = 'South America'

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects