-- 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 ] |
-- -- Within the year of 2001 to 2010, find the paper published rate of 2001.

SELECT CAST(SUM(CASE WHEN Year = 2001 THEN 1 ELSE 0 END) AS REAL) / COUNT(Id) FROM Paper WHERE Year >= 2001 AND Year < 2011;