Expected Output:
customer_id first_name last_name phone email
NULL
6
49
1031
1123
1392
Lyndsey Bean
Caroll
Hays
Tonja
Bean
Raphael O'neil
Trista
lyndsey.bean@hotmail.com
caroll.hays@yahoo.com
NULL
NULL tonja.bean@aol.com
NULL raphael.oneil@aol.com
Lambert NULL trista lambert@gmail.com
street
769 West Road
9381 Wrangler St.
9 Middle River St.
762 East Lantem Dr.
79 River Street
city
Fairport NY
state zip code
14450
Fairport NY
14450
Fairport NY
14450
Fairport NY
14450
Fairport NY 14450
Fig: 1