Which customer addresses are no longer active?
no longer active refers to address_status = 'Inactive'; customer address refers to street_number, street_name, city
SELECT DISTINCT T1.street_name FROM address AS T1 INNER JOIN customer_address AS T2 ON T1.address_id = T2.address_id INNER JOIN address_status AS T3 ON T3.status_id = T2.status_id WHERE T3.address_status = 'Inactive'