CREATE VIEW home_assistant.v_statistics_join
(
    `id` Int64,
    `created` String,
    `created_ts` Float64,
    `metadata_id` Int64,
    `start` String,
    `start_ts` Float64,
    `mean` Float64,
    `min` Float64,
    `max` Float64,
    `last_reset` String,
    `last_reset_ts` Float64,
    `state` Float64,
    `sum` Float64,
    `m.id` Int64,
    `statistic_id` String,
    `source` String,
    `unit_of_measurement` String,
    `has_mean` String,
    `has_sum` String,
    `name` String
)
AS SELECT *
FROM home_assistant.statistics AS s
INNER JOIN home_assistant.statistics_meta AS m ON s.metadata_id = m.id