You are working on a data transformation project using Azure Synapse Analytics. You have a table with customer transaction data, and you need to calculate the total revenue generated by each customer. Which of the following T-SQL queries would you use to achieve this?

Simulated

SELECT customer_id, SUM(transaction_amount) AS total_revenue FROM transaction_table GROUP BY customer_id_

100.0%

SELECT customer_id, transaction_amount FROM transaction_table ORDER BY total_revenue DESC

0.0%

SELECT customer_id, AVG(transaction_amount) AS average_revenue FROM transaction_table GROUP BY customer_id_

0.0%

SELECT customer_id, MAX(transaction_amount) AS max_revenue FROM transaction_table GROUP BY customer_id_

0.0%

Microsoft Azure Data Engineer Associate - DP-203