SQL编写——查询最近的年份的人均收入与去年的人均收入百分比

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="AgriculturalDataOverviewMapper">


<!-- 济南市农业产业年度生产总值 -->
<select id="TotalValue" parameterType="page" resultType="pd">
SELECT
RECORDYEAR,
AFAHTOTAL
FROM
t_info_afah
WHERE RECORDYEAR=(select MAX(RECORDYEAR) from t_info_afah)
</select>
<!-- 农名人均收入 -->
<select id="perCapitaTotal" parameterType="page" resultType="pd">
SELECT
RE