Question: Question 1 4 ( 1 point ) Which SQL query retrieves customers with a total revenue over 1 0 , 0 0 0 from the

Question 14(1 point)
Which SQL query retrieves customers with a total revenue over 10,000 from the "transactions" table?
SELECT customer_id, SUM(revenue) FROM transactions HAVING SUM(revenue)>10000
SELECT customer_id, SUM(revenue) FROM transactions WHERE revenue >10000 GROUP BY customer_id
SELECT customer_id, SUM(revenue) FROM transactions GROUP BY customer_id WHERE SUM(revenue)>10000
SELECT customer_id, SUM(revenue) FROM transactions GROUP BY customer_id HAVING SUM revenue
Question 1 4 ( 1 point ) Which SQL query

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!