Show the information of the customer with first name Art and last name Turcotte.
select * from customers where customer_first_name = "Art" and customer_last_name = "Turcotte"
Please show the account information of this customer.
select * from accounts as t1 join customers as t2 on t1.customer_id = t2.customer_id where t2.customer_first_name = "Art" and t2.customer_last_name = "Turcotte"
How many accounts are there?
select count(*) from accounts as t1 join customers as t2 on t1.customer_id = t2.customer_id where t2.customer_first_name = "Art" and t2.customer_last_name = "Turcotte"