Hello, I was wondering how many accounts are listed under the first name of John?
select count ( distinct account_id ) from customers as t1 join accounts as t2 on t2.customer_id = t1.customer_id where customer_first_name = 'John'
How about Meaghan or Jessica?
select count ( distinct account_id ) from customers as t1 join accounts as t2 on t2.customer_id = t1.customer_id where customer_first_name = 'Meaghan' or customer_first_name = 'Jessica'
Okay, could you just give me the account names listed under Meaghan first?
select account_name from customers as t1 join accounts as t2 on t2.customer_id = t1.customer_id where customer_first_name = 'Meaghan'
And what are the id's for those accounts?
select account_id from customers as t1 join accounts as t2 on t2.customer_id = t1.customer_id where customer_first_name = 'Meaghan'
Thank you so much, now back to the accounts listed for Jessica.  What are the account names of those?
select account_name from customers as t1 join accounts as t2 on t2.customer_id = t1.customer_id where customer_first_name = 'Jessica'