Which SQL statement lets you find the sales amount for each store.

Q. Which SQL statement lets you find the sales amount for each store ?

(a) SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES ;

(b) SELECT STORE_ID,  SUM (SALES_AMOUNT ) FROM SALES ORDER BY STORE_ID;

(c) SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;

(d) SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES HAVING UNIQUE STORE_ID ;

Consider  this table --

 

You can understand by seeing this video ---

Answer =

(c) = SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;