human
Schema:
Customers (customer_id, customer_first_name, customer_middle_initial, customer_last_name, gender, email_address, login_name, login_password, phone_number, town_city, state_county_province, country)
Orders (order_id, customer_id, date_order_placed, order_details)
Invoices (invoice_number, order_id, invoice_date)
Accounts (account_id, customer_id, date_account_opened, account_name, other_account_details)
Product_Categories (production_type_code, product_type_description, vat_rating)
Products (product_id, parent_product_id, production_type_code, unit_price, product_name, product_color, product_size)
Financial_Transactions (transaction_id, account_id, invoice_number, transaction_type, transaction_date, transaction_amount, transaction_comment, other_transaction_details)
Order_Items (order_item_id, order_id, product_id, product_quantity, other_order_item_details)
Invoice_Line_Items (order_item_id, invoice_number, product_id, product_title, product_quantity, product_price, derived_product_cost, derived_vat_payable, derived_total_cost)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the first name and last name for the customer with account name 900.
assistant
SELECT T2.customer_first_name , T2.customer_last_name FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T1.account_name = "900" ;