Show the ids of all customers.
select customer_id from customers
What about those who have address information?
select customer_id from customer_address_history
Show the names of those who don't have it.
select customer_name from customers where customer_id not in (select customer_id from customer_address_history)
Also show their phone numbers.
select customer_name, customer_phone from customers where customer_id not in (select customer_id from customer_address_history)