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, Quilmescitycity_id city1 A Corua (La Corua)2 Abha3 Abu Dhabicountry_id last_update87 2006-02-15 9:4582 2006-02-15 9:45101 2006-02-15 9:454 Acua60 2006-02-15 9:455 Adana97 2006-02-15 9:456 Addis Abeba31 2006-02-15 9:457 Aden8 Adoni9 Ahmadnagar107 2006-02-15 9:4544 2006-02-15 9:4544 2006-02-15 9:45addressaddress_id addressaddress2 districtcity_id postal_code phonelast_update147 MySakila DriveAlberta3002006-02-15 9:452 28 MYSQL BoulevardQLD5762006-02-15 9:453 23 Workhaven LaneAlberta30014033335568 2006-02-15 9:454 1411 Lillydale DriveQLD5766172235589 2006-02-15 9:455 1913 Hanoi WayNagasaki46335200 28303384290 2006-02-15 9:456 1121 Loja AvenueCalifornia44917886 8.38635E+11 2006-02-15 9:457 692 Joliet Street8 1566 Inegl Manor9 53 Idfu ParkwayAttika3883579 4.48477E+11 2006-02-15 9:45Mandalay34953561 7.05814E+11 2006-02-15 9:45Nantou36142399 10655648674 2006-02-15 9:45

The sample tables are created using CREATE TABLE city (city_id int,city text);create table…

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)

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

Related questions