Example 1: |
SELECT COUNTRY, DES_PROD, SITUATION, YEAR_, SUM (Sales) AS Total_Sales FROM Fact_Sales FS, DIM_GEOGRAPHYG, DIM_DATE D, DIM_PRODUCT P, DIM_CUSTOMERS C WHERE FS.ID_CUST=C.ID_CUST AND FS.ID_PROD=P.ID_PROD AND FS.ID_GEO=G.ID_GEO AND FS.ID_DATE=D.ID_DATE GROUP BY COUNTRY, DES_PROD, SITUATION, YEAR_; |