Write a SQL query using window functions to find the second-highest transaction amount for each customer.