Error sql select of subquery

[Huletian]

I wrote an SQL query, in which the left table is connected to another table, and a sub query is used in the on condition (the sub query uses the data of the current row of the parent query), resulting in an error. Please help K

SELECT
	g.`学校编码`,
	g.`学期`,
	g.`学期（日期格式）`,
	g.`学期（中文格式）`,
	g.`诊断模块`,
	g.`教师id`,
	g.`教师姓名`,
	g.`学科`,
	g.`身份证号码`,
	g.`题目数量`,
	g.`其他题目数量`,
	g.`最喜欢题目等级`,
	g.`最终等级权重`,
	g.`最终等级`,
	g.`是否进步教师`,
	g.`是否被关注` ,
	( g.`最终等级权重` - g2.teacher_grade ) AS `进步幅度` 
FROM
	tmp_mv_rp_jyjx_teacher_grade g
	LEFT JOIN rp_jyjx_teacher_grade g2 ON 
	(
		g2.teacher_id_lst = (g.`教师id`-100000)
		AND 
			g2.school_term_id =
			(
			SELECT
				gterm.school_term_id 
			FROM
				rp_jyjx_teacher_grade gterm 
			WHERE
			gterm.school_code = g.`学校编码` 
			AND  gterm.school_term_id < g.`学期`
			
			GROUP BY
				gterm.school_term_id 
			ORDER BY
				gterm.school_term_id DESC 
			LIMIT 1 
			)
			
			
			) 
	LIMIT 1;

> 1105 - TProtocolException, msg: Required field 'node_type' was not present! Struct: TExprNode(node_type:null, type:TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:INT))]), num_children:0, output_scale:-1, is_nullable:true)

[dataalive]

cloud u give us your schema and we will try it