What are first and last names of all customers?
select customer_first_name, customer_last_name from customers
What are their ids?
select customer_id from customers
And what are their number of accounts?
select count ( * ) from accounts as t1 join customers as t2 on t1.customer_id = t2.customer_id group by t1.customer_id
Yes, what type of accounts are there?
select distinct other_account_details from accounts