Show the faculty lines in campus "Humboldt State University" in every year.
select t1.year, t1.faculty from faculty as t1 join campuses as t2 on t1.campus = t2.id where t2.campus = "Humboldt state University"
How about those in campus "Long Beach State University"?
select t1.year, t1.faculty from faculty as t1 join campuses as t2 on t1.campus = t2.id where t2.campus = "Long beach state University"
What is the number of faculty lines in this university in 2003?
select faculty from faculty as t1 join campuses as t2 on t1.campus = t2.id where t1.year = 2003 and t2.campus = "Long beach state University"
How about in 2002?
select faculty from faculty as t1 join campuses as t2 on t1.campus = t2.id where t1.year = 2002 and t2.campus = "Long beach state University"