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
icon
Related questions
Question

I need the full code including(create table, insert) and the output

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
+-
- +
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

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Transaction Processing
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education