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;
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...
Related questions
Question
I need help understanding what would be displayed if I ran this code.
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:
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY