-- Database schema
| Author : Id [ INTEGER ] primary_key , Name [ TEXT ] , Affiliation [ TEXT ] | Conference : Id [ INTEGER ] primary_key , ShortName [ TEXT ] , FullName [ TEXT ] , HomePage [ TEXT ] | Journal : Id [ INTEGER ] primary_key , ShortName [ TEXT ] , FullName [ TEXT ] , HomePage [ TEXT ] | Paper : Id [ INTEGER ] primary_key , Title [ TEXT ] , Year [ INTEGER ] , ConferenceId [ INTEGER ] Paper.ConferenceId = Conference.Id , JournalId [ INTEGER ] Paper.JournalId = Journal.Id , Keyword [ TEXT ] | PaperAuthor : PaperId [ INTEGER ] PaperAuthor.PaperId = Paper.Id , AuthorId [ INTEGER ] PaperAuthor.AuthorId = Author.Id , Name [ TEXT ] , Affiliation [ TEXT ] |
-- -- Calculate the total average number of papers published from 2002 to 2010 under the conference "Information and Knowledge Engineering".

SELECT CAST(COUNT(T1.Id) AS REAL) / COUNT(DISTINCT T1.Year) FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T2.FullName = 'Information and Knowledge Engineering' AND T1.Year >= 2002 AND T1.Year <= 2010;