SELECT T2.customer_name ,  T3.city ,  T1.date_from ,  T1.date_to FROM customer_address_history AS T1 JOIN customers AS T2 ON T1.customer_id  =  T2.customer_id JOIN addresses AS T3 ON T1.address_id  =  T3.address_id
SELECT T2.customer_name ,  T3.city ,  T1.date_from ,  T1.date_to FROM customer_address_history AS T1 JOIN customers AS T2 ON T1.customer_id  =  T2.customer_id JOIN addresses AS T3 ON T1.address_id  =  T3.address_id <table_name> : Addresses col : address_id | line_1_number_building | city | zip_postcode | state_province_county | country row 1 : 1 | 4315 Kerluke Canyon Apt. 800 | Hertafurt | 740 | Nevada | USA row 2 : 2 | 319 Kozey Highway Suite 973 | Edgardoberg | 282 | Colorado | USA row 3 : 3 | 592 Frederique Ridge | Gilbertmouth | 167 | Virginia | USA row 4 : 4 | 01868 Laverna Green | Lake Floyd | 41 | Oklahoma | USA row 5 : 5 | 6017 Price Greens | Gibsonfurt | 873 | District of Columbia | USA row 6 : 6 | 037 Luella Path | North Jairo | 126 | Maryland | USA row 7 : 7 | 044 Greenfelder Fort | East Rickey | 564 | Louisiana | USA row 8 : 8 | 2676 Connelly Islands Apt. 199 | West Kaiatown | 770 | Oregon | USA row 9 : 9 | 6830 Alexanne Forks Apt. 925 | Agustinstad | 248 | Illinois | USA row 10 : 10 | 918 Lauren Drive | Gleasonland | 116 | Kentucky | USA row 11 : 11 | 70345 Marvin Glens Apt. 669 | Lake Katheryn | 505 | Kentucky | USA row 12 : 12 | 65854 McKenzie Tunnel | North Lisandroport | 202 | Maine | USA row 13 : 13 | 494 Bruen Radial Apt. 723 | Estaland | 381 | Idaho | USA row 14 : 14 | 794 Doyle Lake Apt. 531 | West Muriel | 571 | Vermont | USA row 15 : 15 | 9590 Rogahn Point Apt. 466 | Port Montytown | 37 | SouthDakota | USA <table_name> : Customers col : customer_id | payment_method_code | customer_number | customer_name | customer_address | customer_phone | customer_email row 1 : 1 | Credit Card | 456 | Kayley | 636 Chanelle Isle Apt. 846 | +87(9)5279161988 | antonette73@example.com row 2 : 2 | Credit Card | 553 | Sterling | 12174 Boyer Crossroad | 896.685.8228x2786 | stroman.chadd@example.net row 3 : 3 | Credit Card | 951 | Buford | 650 Spencer Way Apt. 584 | (192)144-4687 | pattie.mayer@example.net row 4 : 4 | Direct Debit | 497 | Caterina | 075 Skiles Expressway | 387.053.1225 | dbeahan@example.net row 5 : 5 | Direct Debit | 752 | Raymond | 8497 Huel Stravenue | 1-513-427-0125 | bergnaum.ashton@example.com row 6 : 6 | Direct Debit | 838 | Cheyenne | 058 Ben Street Apt. 034 | 009-136-4509x19635 | rhayes@example.org row 7 : 7 | Direct Debit | 429 | Cecelia | 4065 Forest Vista Apt. 103 | 672-559-0630x7875 | caesar.lemke@example.net row 8 : 8 | Credit Card | 564 | Brenna | 440 Aiden Ports | 1-271-345-4681x1131 | macy.huel@example.org row 9 : 9 | Credit Card | 525 | Lela | 13256 Valentina Valleys Suite 292 | 838.718.8618x23239 | vandervort.helena@example.org row 10 : 10 | Credit Card | 795 | Cleo | 91702 Hilpert Pines Suite 177 | 1-202-928-5395 | xrosenbaum@example.org row 11 : 11 | Direct Debit | 233 | Shany | 55270 Carter Street Apt. 214 | 936.929.9929 | kling.jesus@example.com row 12 : 12 | Credit Card | 586 | Madaline | 8428 Cecile Land Apt. 192 | 097-514-4641 | brady.ernser@example.net row 13 : 13 | Direct Debit | 445 | Melissa | 251 Botsford Harbors Suite 399 | 529.148.1926 | howard27@example.com row 14 : 14 | Direct Debit | 735 | Orion | 10823 Rollin Spur | 479-171-6355x66065 | kip.abernathy@example.com row 15 : 15 | Direct Debit | 523 | Ottilie | 4098 Kreiger Knoll Suite 758 | 393-750-2077x72779 | morton06@example.net <table_name> : Customer_Address_History col : customer_id | address_id | date_from | date_to row 1 : 12 | 7 | 2015-07-23 14:37:18 | 2018-03-07 12:04:20 row 2 : 12 | 2 | 2016-11-06 14:33:12 | 2018-03-14 21:36:28 row 3 : 3 | 9 | 2011-11-19 12:17:36 | 2018-03-22 10:20:16 row 4 : 13 | 15 | 2009-02-16 23:04:20 | 2018-03-07 17:47:47 row 5 : 3 | 12 | 2008-06-22 21:50:44 | 2018-03-13 00:08:29 row 6 : 11 | 10 | 2012-04-09 18:10:36 | 2018-03-11 20:16:56 row 7 : 11 | 10 | 2014-11-17 15:11:26 | 2018-03-08 23:31:30 row 8 : 2 | 13 | 2011-01-02 21:42:29 | 2018-02-25 19:55:00 row 9 : 13 | 11 | 2015-05-01 12:44:46 | 2018-03-24 06:20:36 row 10 : 12 | 3 | 2011-06-02 02:53:28 | 2018-03-10 00:47:18 row 11 : 6 | 1 | 2013-06-14 23:07:04 | 2018-03-16 14:49:28 row 12 : 14 | 12 | 2008-10-13 04:37:27 | 2018-03-19 10:10:53 row 13 : 13 | 5 | 2012-03-16 17:42:30 | 2018-02-27 07:31:19 row 14 : 7 | 13 | 2012-11-19 09:20:49 | 2018-03-11 20:11:21 row 15 : 7 | 3 | 2012-11-09 07:15:16 | 2018-03-09 12:03:31 row 16 : 2 | 4 | 2011-11-02 17:31:41 | 2018-03-07 05:29:10 row 17 : 9 | 13 | 2010-03-25 08:23:20 | 2018-03-09 16:41:55 row 18 : 6 | 12 | 2017-10-25 07:35:59 | 2018-03-11 21:40:52 row 19 : 7 | 3 | 2009-05-22 04:42:28 | 2018-03-18 11:13:27 row 20 : 12 | 9 | 2016-12-23 04:42:07 | 2018-03-20 01:13:38
col : customer_name | city | date_from | date_to row 1 : Madaline | East Rickey | 2015-07-23 14:37:18 | 2018-03-07 12:04:20 row 2 : Madaline | Edgardoberg | 2016-11-06 14:33:12 | 2018-03-14 21:36:28 row 3 : Buford | Agustinstad | 2011-11-19 12:17:36 | 2018-03-22 10:20:16 row 4 : Melissa | Port Montytown | 2009-02-16 23:04:20 | 2018-03-07 17:47:47 row 5 : Buford | North Lisandroport | 2008-06-22 21:50:44 | 2018-03-13 00:08:29 row 6 : Shany | Gleasonland | 2012-04-09 18:10:36 | 2018-03-11 20:16:56 row 7 : Shany | Gleasonland | 2014-11-17 15:11:26 | 2018-03-08 23:31:30 row 8 : Sterling | Estaland | 2011-01-02 21:42:29 | 2018-02-25 19:55:00 row 9 : Melissa | Lake Katheryn | 2015-05-01 12:44:46 | 2018-03-24 06:20:36 row 10 : Madaline | Gilbertmouth | 2011-06-02 02:53:28 | 2018-03-10 00:47:18 row 11 : Cheyenne | Hertafurt | 2013-06-14 23:07:04 | 2018-03-16 14:49:28 row 12 : Orion | North Lisandroport | 2008-10-13 04:37:27 | 2018-03-19 10:10:53 row 13 : Melissa | Gibsonfurt | 2012-03-16 17:42:30 | 2018-02-27 07:31:19 row 14 : Cecelia | Estaland | 2012-11-19 09:20:49 | 2018-03-11 20:11:21 row 15 : Cecelia | Gilbertmouth | 2012-11-09 07:15:16 | 2018-03-09 12:03:31 row 16 : Sterling | Lake Floyd | 2011-11-02 17:31:41 | 2018-03-07 05:29:10 row 17 : Lela | Estaland | 2010-03-25 08:23:20 | 2018-03-09 16:41:55 row 18 : Cheyenne | North Lisandroport | 2017-10-25 07:35:59 | 2018-03-11 21:40:52 row 19 : Cecelia | Gilbertmouth | 2009-05-22 04:42:28 | 2018-03-18 11:13:27 row 20 : Madaline | Agustinstad | 2016-12-23 04:42:07 | 2018-03-20 01:13:38