in Databases
1,066 views
0 votes
0 votes

Specify the following queries in SQL on the database schema of Figure 1.2.


Figure 1.2:
A database that stores
student and course
information.Caption

  1. Retrieve the names of all senior students majoring in ‘CS’ (computer science). 
  2. Retrieve the names of all courses taught by Professor King in 2007 and
    2008.
  3. For each section taught by Professor King, retrieve the course number,
    semester, year, and number of students who took the section.
  4. Retrieve the name and transcript of each senior student (Class = 4)
    majoring in CS. A transcript includes course name, course number, credit
    hours, semester, year, and grade for each course completed by the student.
in Databases
by
1.1k views

1 Answer

1 vote
1 vote

1. Select Name from STUDENT where Major = "CS".

Related questions