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

Count the number of cards the customer with the first name Art and last name Turcotte has.
SELECT COUNT(*) FROM customers_cards 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 "customers_cards" AS "T1" JOIN "customers" AS "T2" ON "Art" = "T2"."customer_first_name" AND "T1"."customer_id" = "T2"."customer_id" AND "T2"."customer_last_name" = "Turcotte"