Difference: CSC210S2026Lab1 (2 vs. 3)

Revision 32026-01-14 - CathyBareiss

Line: 1 to 1
 
META TOPICPARENT name="CSC210SylS2026"

SQL Lab 1

Line: 9 to 9
 Questions:

  1. Display all the courses you have taken (course id, section id, and semester) ordered by course_id. You can first look up your id number in the student table. (It may be different from what you use at your institution for privacy reasons). If you prefer, you can do it for any one student of your choice instead.
Changed:
<
<
  1. Find the ids of instructor Kean and instructor Choll. Use that information to display the courses taught by Katz in Fall 2003 or Califieri in Spring 2002.
>
>
  1. Find the ids of instructor Kean and instructor Choll. Use that information to display the courses taught by Kean in Fall 2003 or Choll in Spring 2002.
 
  1. Find the id of instructor Voronina and use it to display the ids of students who were in a music or accounting course taught by Vornina in Fall 2006. Do not use an IN operator.
  2. Repeat the previous question using the IN operator.
  3. Display all courses taught within the Comp. Sci. department that are lower level (not 300 or above).
View topic | History: r4 < r3 < r2 < r1 | More topic actions...
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback