开发多币种 EA 交易（第 18 部分）：考虑远期的自动化组选择·综合运用

-- Request class="num">1
SELECT *
  FROM passes p0
WHERE p0.id_task = class="num">10;
-- Request class="num">2
SELECT p0.id_pass AS I_id_pass,
       p0.is_forward AS I_is_forward,
       p0.custom_ontester AS I_custom_ontester,
       p1.id_pass AS O_id_pass,
       p1.is_forward AS O_is_forward,
       p1.custom_ontester AS O_custom_ontester
  FROM passes p0
       JOIN
       passes p1 ON p0.pass = p1.pass AND
                    p0.is_forward = class="num">0 AND
                    p1.is_forward = class="num">1
WHERE p0.id_task = class="num">10 AND p1.id_task = class="num">10
CREATE TABLE ... AS SELECT ... ;
-- Request class="num">3
DROP TABLE IF EXISTS t0;
CREATE TABLE t0 AS
SELECT id_pass,
       pass,
       is_forward,
       custom_ontester,
       (custom_ontester - MIN(custom_ontester) OVER() ) / (MAX(custom_ontester) OVER() - MIN(custom_ontester) OVER() ) AS s_custom_ontester,
       equity_dd_relative,
       (equity_dd_relative - MIN(equity_dd_relative) OVER() ) / (MAX(equity_dd_relative) OVER() - MIN(equity_dd_relative) OVER() ) AS s_equity_dd_relative,
       profit_factor,
       (profit_factor - MIN(profit_factor) OVER() ) / (MAX(profit_factor) OVER() - MIN(profit_factor) OVER() ) AS s_profit_factor
  FROM passes
WHERE id_task=class="num">10;
SELECT * FROM t0;
-- Request class="num">4
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 AS
SELECT p0.id_pass AS I_id_pass,
       p0.is_forward AS I_is_forward,
       ROUND(p0.s_custom_ontester, class="num">4) AS I_custom_ontester,
       ROUND(p0.s_equity_dd_relative, class="num">4) AS I_equity_dd_relative,
       ROUND(p0.s_profit_factor, class="num">4) AS I_profit_factor,
       p1.id_pass AS O_id_pass,
       p1.is_forward AS O_is_forward,
       ROUND(p1.s_custom_ontester, class="num">4) AS O_custom_ontester,
       ROUND(p1.s_equity_dd_relative, class="num">4) AS O_equity_dd_relative,
       ROUND(p1.s_profit_factor, class="num">4) AS O_profit_factor
  FROM t0 p0
       JOIN
       t0 p1 ON p0.pass = p1.pass AND
                    p0.is_forward = class="num">0 AND
                    p1.is_forward = class="num">1 AND

p0.custom_ontester > class="num">0 AND
p1.custom_ontester > class="num">0;
SELECT * FROM t1;
-- Request class="num">5
SELECT
    ROUND(POW((I_custom_ontester - O_custom_ontester), class="num">2) + POW( (I_equity_dd_relative - O_equity_dd_relative), class="num">2) + POW( (I_profit_factor - O_profit_factor), class="num">2), class="num">4) AS dist,
    *
FROM t1
ORDER BY dist ASC;