Show the names of customers who use Credit Card payment method
select customer_name from customers where payment_method_code = 'Credit Card'
Which of those customers have more than 2 orders?
select t1.customer_name from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where t1.payment_method_code = 'Credit Card' group by t1.customer_id having count ( * ) > 2
Show me their customer addresses
select t1.customer_address from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id where t1.payment_method_code = 'Credit Card' group by t1.customer_id having count ( * ) > 2