What are the first and last names of all customers who don't have an account?
select customer_first_name, customer_last_name from customers except select t1.customer_first_name, t1.customer_last_name from customers as t1 join accounts as t2 on t1.customer_id = t2.customer_id
Can you list the addresses of all customers that have VIP as their other account details?
select t1.customer_address from customers as t1 join accounts as t2 on t1.customer_id = t2.customer_id where t2.other_account_details = 'VIP'
COuld you list the account names of all customers with the letter G or A in their first or last names?
select t2.account_name from customers as t1 join accounts as t2 on t1.customer_id = t2.customer_id where t1.customer_first_name like "%g%" or t1.customer_first_name like "%a%" or t1.customer_last_name like "%g%" or t1.customer_last_name like "%a%"