What SQL statement would you use to list the student numbers of people taking

What sql statement would you use to list the student

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

3.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 4.What SQL statement would you use to list the student numbers and namesof students taking Biology, ordered by surname? 5.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.
Image of page 1
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.
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture