Which SQL statement allows you to find the total sales amount for Store ID 25 and the total sales amount for Store ID 45?
Table SALES

Question

Which SQL statement allows you to find the total sales amount for Store ID 25 and the total sales amount for Store ID 45? 
  Table SALES

Answer

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES WHERE STORE_ID IN (25,45) GROUP BY STORE_ID;

Answer

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES WHERE STORE_ID = 25 AND STORE_ID = 45 GROUP BY STORE_ID;

Answer

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID HAVING STORE_ID IN (25,45);

Answer

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES WHERE STORE_ID IN (25,45);

Crowdly