AI球探--GE0模型每天最低信心指数场次统计

fog5188

查询sql：

1. SELECT t1.*, t2.result
   
2.         , CONCAT(t3.`MainTeam`, '(', t2.sletball, ')(', t2.letball, ')', t3.`GuestTeam`) AS "对阵"
   
3.         , CONCAT(t3.`MainTeamGoal`, ':', t3.`GuestTeamGoal`) AS '比分'
   
4.         , t2.preresult
   
5. FROM (
   
6.         SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, COUNT(1) AS cc
   
7.                 , MIN(ABS(Undefined4)) AS minVal
   
8.         FROM t_analy_result r
   
9.         WHERE r.`AlFlag` = "GE0"
   
10.                 AND r.`PreResult` = 0
    
11.         GROUP BY DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d')
    
12. ) t1, (
    
13.                 SELECT DATE_FORMAT(DATE_SUB(r.`MatchDate`,INTERVAL 12 HOUR), '%Y-%m-%d') AS mdate, ABS(Undefined4) AS val
    
14.                         , r.*
    
15.                 FROM t_analy_result r
    
16.                 WHERE r.`AlFlag` = "GE0"
    
17.                         AND r.`PreResult` = 0
    
18.         ) t2, t_match_his t3
    
19. WHERE t1.mdate = t2.mdate
    
20.         AND t1.minVal = t2.val
    
21.         AND t2.matchId = t3.id
    
22. ORDER BY t1.mdate DESC

复制代码

mrgy

信心指数，有负，有正的。请问是：正的为高，负的为低么？

admin

mrgy 发表于 2021-9-29 19:19
信心指数，有负，有正的。请问是：正的为高，负的为低么？

就看绝对值的....
这个ge0不大理想了。