Week 4 Lab

Task 1

• Command: SELECT * FROM isi_jcr_report_isls WHERE jcr_year = 2007
• Screencast shot: http://screencast.com/t/FhJn7JlHz8

Task 2

• Command: SELECT j_abbr, j_if FROM isi_jcr_report_isls WHERE jcr_year = 2008 and j_if > 1
• Screencast shot: http://screencast.com/t/6iuJ5QYTD