SELECT SUM(PROFIT), product, country
FROM l4_product_dim pd, l4_location_dim ld, financial_fact ff
WHERE pd.product_key = ff.product_key
AND ff.location_key = ld.location_key
GROUP BY product, country
ORDER BY SUM(profit);


SELECT continent, country, product, SUM(discounts)
FROM l4_product_dim pd, l4_location_dim ld, financial_fact ff
WHERE pd.product_key = ff.product_key
AND ff.location_key = ld.location_key
GROUP BY continent, country, product
ORDER BY ld.continent, ld.country;


2014 IS the most profitable

SELECT
    *
FROM
    (
        SELECT
            dd.YEAR
        FROM
            l4_date_dim dd,
            financial_fact ff
        WHERE
            ff.date_key = dd.date_key
        GROUP BY
            dd.YEAR
        ORDER BY SUM(PROFIT) DESC
    )
WHERE
    ROWNUM < 2;


September

SELECT
    *
FROM
    (
        SELECT
            dd.month_name
        FROM
            l4_date_dim dd,
            financial_fact ff,
            l4_product_dim pd
        WHERE
            ff.date_key = dd.date_key
            AND pd.product_key = ff.product_key
            AND product = 'Montana'
        GROUP BY
            dd.month_name
        ORDER BY SUM(PROFIT) DESC
    )
WHERE
    ROWNUM < 2;

    SELECT CONTINENT, SUM(DECODE(YEAR, 2013, sales, 0)) "2013"  , SUM(DECODE(YEAR, 2014, sales, 0)) "2014" , SUM(SALES) Total
FROM l4_date_dim dd, financial_fact ff, l4_location_dim ld
WHERE dd.date_key = ff.date_key
AND ff.location_key = ld.location_key
GROUP BY continent;