Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Given the two tables (city and address), write a SQL query to display the districts in the following list of cities: Qalyub, Qinhuangdao, Qomsheh, Quilmes city city_id city 1A Corua (La Corua) 2 Abha 3 Abu Dhabi country_id last_update 87 2006-02-15 9:45 82 2006-02-15 9:45 101 2006-02-15 9:45 4 Acua 60 2006-02-15 9:45 5 Adana 6 Addis Abeba 7 Aden 8 Adoni 9 Ahmadnagar 97 2006-02-15 9:45 31 2006-02-15 9:45 107 2006-02-15 9:45 44 2006-02-15 9:45 44 2006-02-15 9:45 address address_id address address2 district city_id postal_code phone 147 MySakila Drive last_update 2006-02-15 9:45 Alberta 300 2 28 MYSQL Boulevard 3 23 Workhaven Lane QLD 576 2006-02-15 9:45 Alberta 300 14033335568 2006-02-15 9:45 4 1411 Lillydale Drive QLD 576 6172235589 2006-02-15 9:45 5 1913 Hanoi Way Nagasaki California 463 35200 28303384290 2006-02-15 9:45 6 1121 Loja Avenue 449 17886 8.38635E+11 2006-02-15 9:45 7 692 Joliet Street 8 1566 Inegl Manor 9 53 Idfu Parkway Attika 38 83579 4.48477E+11 2006-02-15 9:45 Mandalay 349 53561 7.05814E+11 2006-02-15 9:45 Nantou 361 42399 10655648674 2006-02-15 9:45

Given the two tables (city and address), write a SQL query to display the districts in the following list of cities: Qalyub, Qinhuangdao, Qomsheh, Quilmes city city_id city 1A Corua (La Corua) 2 Abha 3 Abu Dhabi country_id last_update 87 2006-02-15 9:45 82 2006-02-15 9:45 101 2006-02-15 9:45 4 Acua 60 2006-02-15 9:45 5 Adana 6 Addis Abeba 7 Aden 8 Adoni 9 Ahmadnagar 97 2006-02-15 9:45 31 2006-02-15 9:45 107 2006-02-15 9:45 44 2006-02-15 9:45 44 2006-02-15 9:45 address address_id address address2 district city_id postal_code phone 147 MySakila Drive last_update 2006-02-15 9:45 Alberta 300 2 28 MYSQL Boulevard 3 23 Workhaven Lane QLD 576 2006-02-15 9:45 Alberta 300 14033335568 2006-02-15 9:45 4 1411 Lillydale Drive QLD 576 6172235589 2006-02-15 9:45 5 1913 Hanoi Way Nagasaki California 463 35200 28303384290 2006-02-15 9:45 6 1121 Loja Avenue 449 17886 8.38635E+11 2006-02-15 9:45 7 692 Joliet Street 8 1566 Inegl Manor 9 53 Idfu Parkway Attika 38 83579 4.48477E+11 2006-02-15 9:45 Mandalay 349 53561 7.05814E+11 2006-02-15 9:45 Nantou 361 42399 10655648674 2006-02-15 9:45

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question

I need the answer but without the explanation is OK for me.

 

Given the two tables (city and address), write a SQL query to display the districts in the following list of cities: Qalyub, Qinhuangdao, Qomsheh, Quilmes city city_id city 1 A Corua (La Corua) 2 Abha 3 Abu Dhabi country_id last_update 87 2006-02-15 9:45 82 2006-02-15 9:45 101 2006-02-15 9:45 4 Acua 60 2006-02-15 9:45 5 Adana 97 2006-02-15 9:45 6 Addis Abeba 31 2006-02-15 9:45 7 Aden 8 Adoni 9 Ahmadnagar 107 2006-02-15 9:45 44 2006-02-15 9:45 44 2006-02-15 9:45 address address_id address address2 district city_id postal_code phone last_update 147 MySakila Drive Alberta 300 2006-02-15 9:45 2 28 MYSQL Boulevard QLD 576 2006-02-15 9:45 3 23 Workhaven Lane Alberta 300 14033335568 2006-02-15 9:45 4 1411 Lillydale Drive QLD 576 6172235589 2006-02-15 9:45 5 1913 Hanoi Way Nagasaki 463 35200 28303384290 2006-02-15 9:45 6 1121 Loja Avenue California 449 17886 8.38635E+11 2006-02-15 9:45 7 692 Joliet Street 8 1566 Inegl Manor 9 53 Idfu Parkway Attika 38 83579 4.48477E+11 2006-02-15 9:45 Mandalay 349 53561 7.05814E+11 2006-02-15 9:45 Nantou 361 42399 10655648674 2006-02-15 9:45
Transcribed Image Text:Given the two tables (city and address), write a SQL query to display the districts in the following list of cities: Qalyub, Qinhuangdao, Qomsheh, Quilmes city city_id city 1 A Corua (La Corua) 2 Abha 3 Abu Dhabi country_id last_update 87 2006-02-15 9:45 82 2006-02-15 9:45 101 2006-02-15 9:45 4 Acua 60 2006-02-15 9:45 5 Adana 97 2006-02-15 9:45 6 Addis Abeba 31 2006-02-15 9:45 7 Aden 8 Adoni 9 Ahmadnagar 107 2006-02-15 9:45 44 2006-02-15 9:45 44 2006-02-15 9:45 address address_id address address2 district city_id postal_code phone last_update 147 MySakila Drive Alberta 300 2006-02-15 9:45 2 28 MYSQL Boulevard QLD 576 2006-02-15 9:45 3 23 Workhaven Lane Alberta 300 14033335568 2006-02-15 9:45 4 1411 Lillydale Drive QLD 576 6172235589 2006-02-15 9:45 5 1913 Hanoi Way Nagasaki 463 35200 28303384290 2006-02-15 9:45 6 1121 Loja Avenue California 449 17886 8.38635E+11 2006-02-15 9:45 7 692 Joliet Street 8 1566 Inegl Manor 9 53 Idfu Parkway Attika 38 83579 4.48477E+11 2006-02-15 9:45 Mandalay 349 53561 7.05814E+11 2006-02-15 9:45 Nantou 361 42399 10655648674 2006-02-15 9:45
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS