查询条件为当前年份减一的情况
SELECT
company_register companyRegister,
company_name companyName,
company_year companyYear,
company_month companyMonth,
company_paytaxes,
company_subsidy ,
SUM(company_paytaxes) paytaxes,
SUM(company_subsidy) subsidy
FROM
ind_fscreen_nsbt
WHERE is_valid = 1
AND company_year = YEAR(DATE_SUB(NOW(), INTERVAL 1 YEAR))
AND company_register = '530111775541814'