Data Table StateName · StatePopulation - Capital California PopulationCapital - Biggest City PopulationBiggestCity 500930 Los Angeles 39747267 Sacremento 3966940 Техas 29087070 Austin 2321960 Houston 995347 Florida 21646155 Tallahassee 196237 Jacksonville 920577 New York 19491339 Albany 12813969 Harrisburg 12700381 Springfield 95909 New York City 8283550 Pennsylvania 49333 Philadelphia 1584540 llinois Ohio Georgia North Carolina Michigan 116250 Chicago 2686530 11718568 Columbus 906237 Columbus 906237 10627767 Atlanta 515439 Atlanta 515439 10497741 Raleigh 478824 Charlotte 898902 10020472 Lansing 118489 Detroit 667085 Code SELECT StateName, Capital, PopulationCapital, BiggestCity, PopulationBiggestCity, PopulationBiggestCity-PopulationCapital FROM State WHERE PopulationBiggestCity-PopulationCapital>1000000 ORDER BY PopulationBiggestCity-PopulationCapital DESC;

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

I need help understanding what would be displayed if I ran this code.

Data Table
StateName
StatePopulation -
Capital
PopulationCapital - Biggest City - PopulationBiggestCity
4.
4.
California
500930 Los Angeles
39747267 Sacremento
3966940
Техas
29087070 Austin
2321960 Houston
995347
Florida
21646155 Tallahassee
196237 Jacksonville
920577
New York
19491339 Albany
95909 New York City
8283550
Pennsylvania
12813969 Harrisburg
49333 Philadelphia
1584540
Illinois
12700381 Springfield
116250 Chicago
2686530
Ohio
11718568 Columbus
906237 Columbus
906237
Georgia
10627767 Atlanta
515439 Atlanta
515439
North Carolina
Michigan
10497741 Raleigh
478824 Charlotte
898902
10020472 Lansing
118489 Detroit
667085
Code
SELECT StateName, Capital, PopulationCapital, BiggestCity, PopulationBiggestCity,
PopulationBiggestCity-PopulationCapital
FROM State
WHERE PopulationBiggestCity-PopulationCapital>1000000
ORDER BY PopulationBiggestCity-PopulationCapital DESC;
Transcribed Image Text:Data Table StateName StatePopulation - Capital PopulationCapital - Biggest City - PopulationBiggestCity 4. 4. California 500930 Los Angeles 39747267 Sacremento 3966940 Техas 29087070 Austin 2321960 Houston 995347 Florida 21646155 Tallahassee 196237 Jacksonville 920577 New York 19491339 Albany 95909 New York City 8283550 Pennsylvania 12813969 Harrisburg 49333 Philadelphia 1584540 Illinois 12700381 Springfield 116250 Chicago 2686530 Ohio 11718568 Columbus 906237 Columbus 906237 Georgia 10627767 Atlanta 515439 Atlanta 515439 North Carolina Michigan 10497741 Raleigh 478824 Charlotte 898902 10020472 Lansing 118489 Detroit 667085 Code SELECT StateName, Capital, PopulationCapital, BiggestCity, PopulationBiggestCity, PopulationBiggestCity-PopulationCapital FROM State WHERE PopulationBiggestCity-PopulationCapital>1000000 ORDER BY PopulationBiggestCity-PopulationCapital DESC;
Expert Solution
Step 1

Code:

  -- selecting required column names
    SELECT statename,capital,populationcapital,biggestcity,populationbiggestcity,populationbiggestcity-populationcapital
    -- from the state table
    FROM state
    -- condition to check whether the minus of populationbiggestcity and populationcapital greater than 1000000
    WHERE populationbiggestcity-populationcapital>1000000
    -- printing the result i.e.,populationbiggestcity-populationcapital in descending order
    ORDER BY populationbiggestcity-populationcapital DESC;
    

 

Table:

Computer Engineering homework question answer, step 1, image 1

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY