ForAssign8.docx - CS 200 Assignment 8 \u2014 SQL 1 Copy the Assignment File Assign8 to your Documents folder rename your file yHC_Assignment8_Q1

ForAssign8.docx - CS 200 Assignment 8 u2014 SQL 1 Copy the...

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

CS 200 Assignment 8 — SQL 1. Copy the Assignment File : Assign8.doc to your Documents folder rename your file yHC_Assignment8_Q1.doc or (yHC1_yHC2_Assignment8_q1.doc if you are working in pair). Using MS Word, insert your input and/or output after each sub-question below. Please format your answers with the styles AnswerTop, Answer, AnswerBot , and SQL_Output (for tabular SQL output, where requested), which are already in Assign8.doc. Approximately 7% of the marks for this question are reserved for proper formatting of your answer within Assign8.doc. [75%] In InteractiveSQL create the appropriate statements to answer the queries below: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, c)What SQL statement would you use to list the student numbers and namesofstudents taking Biology, ordered by surname?
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture