select count(*) as num,
IFNULL((FORMAT( AVG(elapsed_time), 2) ),0)as elapsedTime(获取耗时),
IFNULL(FORMAT( (select count(*) from mechanism_model_library where `status`='3')/count(*)*100, 2),0) as successRate(获取成功率),
IFNULL(FORMAT(AVG(IFNULL(Round((run_time_evaluation+accuracy_evaluation+readability_evaluation)/3,1),0))*100, 2),0) as appraise(获取平均评分)
from 表名
sql获取总数。平均值,概率值
于 2023-09-09 10:37:31 首次发布