Question 1

1 Select * from students
where (class = "3C")
order by name asc;
2 Select * from books
where (subject = "Science")
order by title desc;
3 Select * from students, loans
where (students.student_id = loans.student_id)
and (students.class = "3D");
4 Select * from books, loans
where (books.ISBN = loans.ISBN)
and (books.subject = "English");

Question 2

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

2 Select * from students
where (name like "%Angela%")
order by class asc, no asc;
3 Select * from students
where (class like "3%") and
(id not like "s07%");
4 Select * from students, marks
where (students.id = marks.id) and
(students.name like "Tsang Hoi Yan%");
5 Select * from students, marks
where (students.id = marks.id) and
(students.class = "3E") and
(marks.subject = "English");