Unknown column 'id' in 'field list'<br/>33333
insert into temp1
select
concat(floor((id-4)/12)+1998,'/',substring(floor((id-4)/12)+1999,3,2)) as year,
sum(animals_slaughtered) as animals_slaughtered
from animals_tested_and_slaughtered_1998_to_2010
where yearmonth>=199804
group by concat(floor((id-4)/12)+1998,'/',substring(floor((id-4)/12)+1999,3,2))