SQL Assignment Question 2

(a) Select * from students where (class="3A") and (no<=10);

(b) Select * from students where (name like "%Angela") order by class asc, no asc;

(c) Select * from students where (class like "3%") and (id not like "s08%");

(d) Select * from students, marks where (students.id = marks.id) and (name like "Tsang Hoi Yan%");

(e) Select * from students, marks where (students.id = marks.id) and (class="3E") and (subject="English");