What sql statement would you use to count the number

What SQL statement would you use to
count the number
of students taking
Biology? And what is the answer?
6. What SQL statement would you use to
list the assignments (and exams)
for
Biology? Please include the output, formatted as a table.
7. What SQL statement would you use to list the student number, course code,
assignment number, assignment description, assignment weight, and mark
for all the philosophy marks for the student with ID 86088? Please include
the output, formatted as a table.
8. What SQL statement would you use to compute the final course grade in
philosophy for the student with ID 86088? And what is the answer?
9. What SQL statement would you use to list the final course grades for
students in Philosophy? Please include the first ten lines of the answer,
formatted as a table.
10. What SQL Select statement would you use to compute the final course
grade in philosophy, for students who also took Biology? Please include the
output, formatted as a table.
Bonus
(5 marks)
11. What SQL statement would you use to determine if there is more than one
student with the same last name in the database? List the people in
alphabetical order (by initials) only once.
CS 200 SQL Page 1