How many papers were published in 2005. Calculate the difference between the number of paper published in 2005 and the number of paper published in the previous year.
published in 2005 refer to Year = 2005; Difference refer to SUBTRACT(SUM(Year = 2005). SUM(Year = 2004))
SELECT SUM(CASE WHEN Year = 2005 THEN 1 ELSE 0 END) , SUM(CASE WHEN year = 2005 THEN 1 ELSE 0 END) - SUM(CASE WHEN year = 2004 THEN 1 ELSE 0 END) AS diff FROM Paper
database name:db_id authors
Author table Author Cols: Id dtype integer, Name dtype text, Affiliation dtype text, 
Conference table Conference Cols: Id dtype integer, ShortName dtype text, FullName dtype text, HomePage dtype text, 
Journal table Journal Cols: Id dtype integer, ShortName dtype text, FullName dtype text, HomePage dtype text, 
Paper table Paper Cols: Id dtype integer, Title dtype text, Year dtype integer, ConferenceId dtype integer, JournalId dtype integer, Keyword dtype text, 
PaperAuthor table PaperAuthor Cols: PaperId dtype integer, AuthorId dtype integer, Name dtype text, Affiliation dtype text, 
