Week 4 Lab

 In the above screen shot, I used the query: SELECT * FROM isi_jcr_report_isls i WHERE j_abbr = 'ANNU REV INFORM SCI' AND jcr_year = 2007. The results brought up one journal that fit the query.

In the screen shot below, I used the query: SELECT j_abbr, j_if FROM isi_jcr_report_isls WHERE jcr_year = 2008 AND j_if > 1. The results indicate that there are 27 journals with impact factors higher than 1 in isi_jcr_report_isls.