Question 6: Following the table below, which SQL statement will find the sales amount of each store? – LLODO

A. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG;

B. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG ORDER BY ID_CUAHANG;

C. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG GROUP BY ID_CUAHANG;

D. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG HAVING UNIQUE ID_CUAHANG;