mysql中出现的语法问题

Question

问题遇到的现象和发生背景

cvs文件导入MYSQL后
用SELECT MAX(金额),MIN(金额) from sheet1;查询sheet1表的最大值和最小值，显示结果不对

问题相关代码，请勿粘贴截图

SELECT MAX(金额),MIN(金额) from sheet1;

运行结果及报错内容

我想要达到的结果

Answer 1

SELECT MAX(CAST(金额 AS   DECIMAL)),MIN(CAST(金额 AS   DECIMAL)) from sheet1;