CREATE TABLE customers AS
SELECT id customer_id, gender,
        get_age_group(birth_date) agegroup, fix_status(marital_status) marital_status,
        get_income_level(income_level) income_level
FROM xsales.customers;

CREATE TABLE products AS
SELECT p.identifier product_id, p.name productname,
        c.name categoryname, p.list_price
FROM xsales.products p JOIN xsales.categories c ON p.subcategory_reference = c.id;

CREATE TABLE orders AS
SELECT o.id order_id, oi.product_id, o.customer_id,
        o.order_finished - oi.order_date days_to_process,
        oi.amount price, oi.COST, o.channel
FROM xsales.orders o JOIN xsales.order_items oi ON o.id = oi.order_id;