"""SELECT 
c.Customer_SSN_ID AS "Customer ID",
c.First_Name || ' ' || c.Last_Name AS "Customer Name",  -- Concatenate first and last name
c.Email,
ct.Account_Balance AS "Account Balance"

FROM customer c JOIN customer_transaction ct ON c.Customer_SSN_ID = ct.Customer_ID WHERE c.Customer_SSN_ID = 1; -- Specify the Customer ID to check details