How do I write an SQL statement using the data table to find out what the names, in alphabetical order, of the Great Lakes that have shorelines in both Canada and the U S are Data Table In Country On Lake Shorline Canada Lake Erie 400 United States Lake Erie 470 Canada Lake Huron 1000 United States Lake Huron 850 United States Lake Michigan 1600 Canada Lake Nipigon 150 Canada Lake Ontario 360 United States Lake Ontario 300 Canada Lake Superior 750 United States Lake Superior 1000

The Answer is in the image, click to view ...

Question: How do I write an SQL statement using the data table to find out what the names, in alphabetical order, of the Great Lakes that

How do I write an SQL statement using the data table to find out what the names, in alphabetical order, of the Great Lakes that have shorelines in both Canada and the U.S. are?

Data Table
In_Country	On_Lake	Shorline
Canada	Lake Erie	400
United States	Lake Erie	470
Canada	Lake Huron	1000
United States	Lake Huron	850
United States	Lake Michigan	1600
Canada	Lake Nipigon	150
Canada	Lake Ontario	360
United States	Lake Ontario	300
Canada	Lake Superior	750
United States	Lake Superior	1000

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!

I would greatly appreciate any help on this, this is an assignment in MySQL. Thank you in advance! 1) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id,...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

Write an SQL statement to create a table room with the attributes (roomNo,hotelNo,hotelName,address,city,type,price,floor,guestNo), specify that the attribute roomNo cannot be null, the attributes...

SQL Assignment SQL, Structure Query Language, is a programming language designed to manage data in relational database systems. It is the language running behind the scenes of a number of database...

1 . Write a SQL statement to create a table named hr _ projects to store the information about the projects being run in the company. Identify to the best of your knowledge proper keys ( primary and...

Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen shots of running commands for Part 2. Submit answers to Part 4...

Screen shot all table and answer about this database problem Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen shots...

Find E field at a distance of 10 cm from the center of the sphere having unifrom charge density of 2 micro c/m2 of radius 5m.

A firm whose shares traded at three times their book value on December 31, 2008, had the accompanying financial statements. Amounts are in millions of dollars. The firm's marginal tax rate is 33...

Use the following returns for X and Y . YearReturnsXY 1 2 1 . 9 % 2 6 . 7 % 2 1 6 . 9 3 . 9 3 9 . 9 2 8 . 7 4 1 9 . 8 1 4 . 8 5 4 . 9 3 2 . 7 Calculate the average returns for X and Y . Note: Do not...

The phrase the next operation is a customer refers to: a . Fostering the culture of internal customer for better cooperation among departments b . Zero Defects for the next process c . Do it right...

Challenges Facing Todays Organizations?

Think of a situation when an organization you belonged to was faced with criticism. Was the organization open to suggestions for change, or was it closed off from such discussions? What was the end...

B How does your opinion of the company policy on dating at work factor into your decision? Does the impact of your coworkers flirtation change your opinion of the policy?