Show the account name and other account detail for all accounts by the customer with first name Meaghan and last name Keeling?
SELECT 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" AND T2.customer_last_name   =   "Keeling"
accounts by a specific customer refers to JOIN on customer_id between Accounts and Customers tables; customer's first name and last name filtering refers to WHERE condition on customer_first_name and customer_last_name;