Q10: Which SQL statement allows you to find the total sales of stores with ID 25 and stores with ID 45? – LLODO

A. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG WHERE ID_CUAHANG IN (25,45) GROUP BY ID_CUAHANG;

B. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG GROUP BY ID_CUAHANG HAVING ID_CUAHANG IN (25,45);

C. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG WHERE ID_CUAHANG IN (25,45);

D. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG WHERE ID_CUAHANG = 25 AND ID_CUAHANG = 45 GROUP BY ID_CUAHANG;