【其他】c_normalize只适用于单表

SELECT
    sf.instrument,
    sf.date as date,
    sf.total_market_cap,

    -- 从技术指标表中选择的字段
    ta.ma_golden,
    ta.ma_long,
    ta.volume_golden,
    ta.volume_long,
    ta.three_red_soldiers,
    ta.hammer,
    ta.morning_star,
    ta.kdj_golden,
    ta.kdj_long,
    0.4 * c_normalize(sf.total_market_cap) + 0.6 * c_normalize(sf.dividend_yield_ratio, sf.date) + 1 * c_normalize(ta.kdj_k - ta.kdj_d, sf.date)  AS score,
    

FROM
    cn_stock_factors AS sf
JOIN
    cn_stock_factors_ta AS ta
ON
    sf.instrument = ta.instrument AND sf.date = ta.date