Week 4 Lab

Task 1:

-Find journal impact factor for Annu Rev Inform Sci in the year 2007.

-MySQL command: SELECT * FROM isi_jcr_report_isls WHERE  j_abbr = 'ANNU REV INFORM SCI' AND  jcr_year = 2007

-Answer: Impact Factor is 1.936

Task 2:

-Find all journals with impact factor > 1 in year 2008.

-MySQL command: SELECT j_abbr, j_if FROM isi_jcr_report_isls WHERE jcr_year = 2008 and j_if > 1

-Answer: See figure below.