2a.
Select * from students
where (class = "3A")
and (no <=10)
order by class, no;

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

2c.
Select * from students
where (id not like "s07%") and (class like "3%")
order by class, no;

2d.
Select *from students, marks
where (name like "%Tsang Hoi Yan%") 

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