Question: Using World database on MySQL Server as the sample database, write SQL statements to solve the following questions (5points/each). 6. List all the countries in

Using World database on MySQL Server as the sample database, write SQL statements to solve the following questions (5points/each).

6. List all the countries in North America, and sort the result first by region, and second by surface area in descending order.

7. Find out what is the official language in USA, Canada, China, Mexico, and Brazil.

8. Find out the city that has the largest population in China (need to display both the name of the city and the population).

9. Find out the city that has the lowest population in the USA (need to display both the name of the city and the population).

10. Find out the top 10 cities that have the largest population in the USA (need to display both the name of the cities and the corresponding population).

The world database is found online but I just need the sql statements. Please and Thank you!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using World database on MySQL Server as the sample database, write SQL statements to solve the following questions (5points/each). 1. Select the cities (*) in the United States of America or Brazil,...

Using World database on MySQL Server as the sample database, write SQL statements to solve the following questions (5points/each). 1. In which countries English and two or more other languages are...

have the value Junior. Write SQL statements to insert the data into each of the five Garden Glory Database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in...

Overview In this project, you will analyze the requirements for, design, implement, and document a database system that could support the functions of a sales company with E - Commerce. This is a...

James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased form jewelry vendors, including such items as rings, necklaces, earrings, and watches, it...

Write SQL statements to answer the following questions using Assignment 2s schema (Customer-Invoice-Line-Product-Vendor). (Please see attached images from assignment 2) 1 - Find the count of unique...

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

Hi, I have areport due in nine hours. I need to find the following list of things on Amazon.com....

Management 587 Case/Assignment/Summary Activity Name Texas A&M-Commerce In partial fulfillment of the requirements for MGT 587 Professor Lloyd M. Basham June 8, 2014 (The above [and the next 3 lines]...

Determine the hybridization and geometry around the indicated carbon atoms. Atom A: sp hybridized sp hybridized sp hybridized linear tetrahedral trigonal planar C H3C CH3 CH B Atom B: CH CH3 A sp...

1) Jeep has a long history of customer loyalty despite many of faults. You can buy a fully loaded Wrangler for over $42,000. The assignment is "WHY!" Focus on the Wrangler model (it is the one that...

Find the future value of each annuity $57,000; money earns 6% compounded semiannually for 8 1/2 years

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

2. Whos in favor of net neutrality? Whos opposed? Why? What kind of Internet user are you? Do you primarily use the Net to do a little e-mail and online banking? Or are you online all day, watching...

Ethics. Teamwork. Assume that you have been employed by a company for five years. Your experiences with the company have been generally positive, but you have not received the promotions and salary...

3. What would be the impact on individual users, businesses, and government if Internet providers switched to a tiered service model for transmission over land lines as well as wireless? What kind of...