AI球探--GE0模型每天最低信心指数场次统计
查询sql:
SELECT t1.*, t2.result
, CONCAT(t3.`MainTeam`, '(', t2.sletball, ')(', t2.letball, ')', t3.`GuestTeam`) AS "对阵"
, CONCAT(t3.`MainTeamGoal`, ':', t3.`GuestTeamGoal`) AS '比分'
, t2.preresult
FROM (
SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, COUNT(1) AS cc
, MIN(ABS(Undefined4)) AS minVal
FROM t_analy_result r
WHERE r.`AlFlag` = "GE0"
AND r.`PreResult` = 0
GROUP BY DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d')
) t1, (
SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, ABS(Undefined4) AS val
, r.*
FROM t_analy_result r
WHERE r.`AlFlag` = "GE0"
AND r.`PreResult` = 0
) t2, t_match_his t3
WHERE t1.mdate = t2.mdate
AND t1.minVal = t2.val
AND t2.matchId = t3.id
ORDER BY t1.mdate DESC
信心指数,有负,有正的。请问是:正的为高,负的为低么? mrgy 发表于 2021-9-29 19:19
信心指数,有负,有正的。请问是:正的为高,负的为低么?
就看绝对值的....
这个ge0不大理想了。
页:
[1]