Week4 Lab

Task1

SQL Query:

SELECT * FROM isi_jcr_report_isls

WHERE j_abbr = 'ANNU REV INFORM SCI'

AND jcr_year = 2007

Task2

SQL Query:

SELECT j_abbr, j_if
FROM isi_jcr_report_isls
WHERE jcr_year = 2008
and j_if > 1