query to optimize

DEMO - optimize

SELECT
    c.c_customer_id,
    c.c_first_name,
    c.c_last_name,
    d.d_moy,
    d.d_year,
    SUM(s.sales_amount) AS total_sales
FROM
    (
        SELECT
            c_customer_id,
            c_first_name,
            c_last_name,
            c_birth_month,
            c_birth_year,
            c_current_hdemo_sk
        FROM customer
        WHERE c_birth_country = 'CHILE'
    ) c
JOIN
    (
        SELECT
            d_moy,
            d_year,
            d_date_sk
        FROM date_dim
        WHERE d_year = 2023
    ) d ON 1=1
JOIN
    (
        SELECT
            ss_customer_sk,
            ss_net_paid
        FROM store_sales
    ) s ON c.c_customer_sk = s.s_customer_sk
        AND d.d_date_sk = s.s_sold_date_sk
GROUP BY
    c.c_customer_id,
    c.c_first_name,
    c.c_last_name,
    d.d_moy,
    d.d_year;