Week 4 Lab

Task 1 SQL Query:

SELECT * FROM isi_jcr_report_isls i

WHERE j_abbr = “ANNU REV INFORM SCI”

AND jcr_year = 2007

Task 2 SQL Query

SELECT * FROM isi_jcr_report_isls i

WHERE jcr_year = 2008

AND j_if>1