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_;