What SQL statement would you use to count the number of students taking Biology

What sql statement would you use to count the number

This preview shows page 1 - 2 out of 2 pages.

What SQL statement would you use to count the numberof 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 onestudent with the same last name in the database? List the people in alphabetical order (by initials) only once. CS 200 SQL Page 1
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture