" Week 4 Lab"

Task 1

 

SELECT * FROM isi_jcr_report_isls

WHERE j_abbr='ANNU REV INFORM SCI'

AND jcr_year=2007

Task 2

SELECT j_abbr, j_if

FROM isi_jcr_report_isls

WHERE jcr_year=2008

AND j_if > 1