Query that gets customers activity

find_customer_events.sql

SELECT
    *
FROM
    (
        SELECT
            c.ts AS event_date,
            c.event,
            c.type AS event_type,
            c.result,
            customer_id
        FROM
            commons.customer_events_marketing c
        UNION ALL
        SELECT
            purchase_date,
            'Store Visit' AS event,
            'Purchase' AS event_type,
            concat('$ ', cast(item_cost as varchar(100))) as result,
            cast(customer_id AS VARCHAR) AS customer_id
        FROM
            commons.orders o
        WHERE
            o.is_refunded = False
        UNION ALL
        SELECT
            purchase_date,
            'Store Visit' AS event,
            'Refund' AS event_type,
            concat('$ -', cast(item_cost as varchar(100))) as result,
            cast(customer_id AS VARCHAR) AS customer_id
        FROM
            commons.orders o
        WHERE
            o.is_refunded = True
    ) a
WHERE
    customer_id = :customer_id