Assume you have a table in your database called World' with the following schema: Table: World | Column Name | Type | name | continent | varchar | | varchar | | area int
Assume you have a table in your database called World' with the following schema: Table: World | Column Name | Type | name | continent | varchar | | varchar | | area int
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
I need the full code including(create table, insert) and the output

Transcribed Image Text:Assume you have a table in your database called World' with the following schema:
Table: world
| Column Name | Type
+-
| varchar |
| varchar |
| int
| int
| int
| name
| continent
|area
|
I population
I gdp
|
+--
name is the primary key column for this table.
Each row of this table gives information about the name of a country, the
continent to which it belongs, its area, the population, and its GDP value.
It contains the following records of data:
Input:
World table:
+--
| name
| continent | area
I population | gdp
+--
| Afghanistan | Asia
| Albania
| Algeria
| Andorra
| Angola
| 652230
| 28748
| 2381741 | 37100000
| 468
| 1246700 | 20609294
| 20343000000
| 12960000000
| 188681000000 |
| 3712000000
| 100990000000 |
| 25500100
| 2831741
| Europe
| Africa
| Europe
| Africa
| 78115
+-
Write an SQL query to report the name, population, and area of the big countries.
Return the result table in any order.
A country is big if:
it has an area of at least three million (i.e., 3000000 km2), or
• it has a population of at least twenty-five million (i.e., 25000000).
The results should be:
Output:
+-
| name
I population | area
+--
| Afghanistan | 25500100
| Algeria
| 652230
| 2381741 |
| 37100000
+-
- +
Expert Solution

Step 1
NOTE: I have given the answer as asked in the question
Solution:
WHERE: conditionally retrieve/get/extract data
To get at least we always use (> greater than operator) to retrieve/get/extract
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education