List the authors and journal short name of the papers with "chemiluminescence" in its title and has a journal ID from 245 to 250.
with "chemiluminescence" in its title refers to Title LIKE 'chemiluminescence%'; journal ID from 245 to 250 refers to JournalId BETWEEN 245 AND 250
SELECT T2.Name, T3.ShortName FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Journal AS T3 ON T1.JournalId = T3.Id WHERE T1.JournalId BETWEEN 245 AND 250 AND T1.Title LIKE '%chemiluminescence%'
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, 
