DOCUSIGN Coding Question – Solved

User Transaction Report for 2023 In the digital age, payment systems are essential for online transactions. For businesses managing these systems, understanding user activity is key to optimizing services and enhancing engagement. A development team is tasked with creating a report that shows: The total number of transactions made by each user. The total sum of those transactions. Analyzing these patterns will help identify highly active users and those who may need additional engagement. Requirements The output of the report should include the following columns: - email: The email address of the user. - total_transactions: The total number of transactions made by the user. - total_amount: The total value of the transactions (rounded to two decimal places, including trailing zeros if needed, e.g., 500.00). The results should be sorted in ascending order by email. Note: Only include transactions that occurred in the year 2023. Schema Table: users id (INT): The identifier of the user email (VARCHAR(255)): The email address of the user Table: transactions user_id (INT): The reference to the user amount (DECIMAL(5,2)): The amount of the transaction created_at (VARCHAR(19)): The date and time of the transaction Foreign Key: user_id references users(id)