a What SQL statement would you use to list the courses known to the database b

A what sql statement would you use to list the

This preview shows page 3 - 4 out of 4 pages.

a)What SQL statement would you use to list the courses known to the database? b)What SQL statement would you use to list the student numbersof people taking Biology? Note that the courses are stored with their course codes, ex. BIOL c)What SQL statement would you use to list the student numbers and namesof students taking Biology, ordered by surnamed)What SQL statement would you use to count the numberof students taking Biology? And what is the answer? e)What SQL statement would you use to list the assignment descriptions (and exams)for Biology? Please include the output, formatted as a table. f)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. g)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? h)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. i)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)
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture