CREATE TABLE Accounts (customer_id VARCHAR(255)); CREATE TABLE Customers (customer_id VARCHAR(255), customer_first_name VARCHAR(255), customer_last_name VARCHAR(255))
How many accounts does the customer with first name Art and last name Turcotte have?
    
SQL: 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"