What are the names and addressed of customers who have both New and Pending orders?
select t1.customer_name, t1.customer_address from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where t2.order_status_code = "New" intersect select t1.customer_name, t1.customer_address from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where t2.order_status_code = "Pending"