What are the names and account balances of customers with the letter a in their names?
SELECT cust_name ,  acc_bal FROM customer WHERE cust_name LIKE '%a%'
names and account balances refers to SELECT cust_name, acc_bal; customers with the letter a in their names refers to WHERE cust_name LIKE '%a%';