Question: Which query would return the total revenue ( ws _ net _ paid ) for orders with a sales price ( ws _ sales _

Which query would return the total revenue (ws_net_paid) for orders with a sales price (ws_sales_price) greater than $50?
SELECT SUM(ws_sales_price) FROM web_sales WHERE ws_sales_price >50;
SELECT AVG(ws_net_paid) FROM web_sales WHERE ws_sales_price >50;
SELECT SUM(ws_net_paid) FROM web_sales WHERE ws_sales_price >50;
SELECT SUM(ws_net_paid) FROM web_sales WHERE ws_net_paid >50;

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!