What is your experience with SQL and database management? Can you write a query utilizing joins and aggregations to extract transaction records?