CREATE TABLE Customers (customer_id VARCHAR2, customer_first_name VARCHAR2)
CREATE TABLE Accounts (account_id VARCHAR2, date_account_opened VARCHAR2, account_name VARCHAR2, other_account_details VARCHAR2, customer_id VARCHAR2)

Show the id, the account name, and other account details for all accounts by the customer with first name 'Meaghan'.
SELECT T1.account_id, T1.date_account_opened, T1.account_name, T1.other_account_details FROM Accounts AS T1 JOIN Customers AS T2 ON T1.customer_id = T2.customer_id WHERE T2.customer_first_name = 'Meaghan'
SELECT "T1"."account_id", "T1"."date_account_opened", "T1"."account_name", "T1"."other_account_details" FROM "Accounts" "T1" JOIN "Customers" "T2" ON "T1"."customer_id" = "T2"."customer_id" AND "T2"."customer_first_name" = 'Meaghan'