Show the account id for all accounts.
select account_id from accounts
Also show the customer first name for these accounts.
select t1.account_id, t2.customer_first_name from accounts as t1 join customers as t2 on t1.customer_id = t2.customer_id
What are the ids for the accounts owned by the customer with first name 'Meaghan'?
select t1.account_id from accounts as t1 join customers as t2 on t1.customer_id = t2.customer_id where t2.customer_first_name = 'Meaghan'
Also show the account name, and other account details for these accounts.
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'