CREATE TABLE financial_transactions (transaction_id NUMBER, previous_transaction_id NUMBER, account_id NUMBER, card_id NUMBER, transaction_type CLOB, transaction_date TIME, transaction_amount NUMBER, transaction_comment CLOB, other_transaction_details CLOB)
CREATE TABLE customers_cards (card_id NUMBER, customer_id NUMBER, card_type_code CLOB, card_number CLOB, date_valid_from TIME, date_valid_to TIME, other_card_details CLOB)
CREATE TABLE customers (customer_id NUMBER, customer_first_name CLOB, customer_last_name CLOB, customer_address CLOB, customer_phone CLOB, customer_email CLOB, other_customer_details CLOB)
CREATE TABLE accounts (account_id NUMBER, customer_id NUMBER, account_name CLOB, other_account_details CLOB)

How many accounts does the customer with first name Art and last name Turcotte have?
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"
SELECT COUNT(*) FROM "accounts" "T1" JOIN "customers" "T2" ON "Art" = "T2"."customer_first_name" AND "T1"."customer_id" = "T2"."customer_id" AND "T2"."customer_last_name" = "Turcotte"