Difference: CSC210S2026Lab1 (3 vs. 4)

Revision 42026-01-19 - CathyBareiss

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

SQL Lab 1

Line: 15 to 15
 
  1. Display all courses taught within the Comp. Sci. department that are lower level (not 300 or above).
  2. Display the names and IDs of all professors in one column with just a space separating the two.
  3. Display all the courses (course_id) that have been taught at least once without an assigned location.
Changed:
<
<
  1. Display all the different unique combinations of semesters and buildings have been taught at the university. What results might be consider missing;
>
>
  1. Display all the different unique combinations of semesters and buildings have been taught at the university. What results might be consider missing?
 
  1. (Bonus) Find students who have taken courses taught by both Tung and Dale.
\ No newline at end of file
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