Query 9: List all stuids which are enrolled in ART 103A and which are enrolled i
ID: 3888882 • Letter: Q
Question
Query 9: List all stuids which are enrolled in ART 103A and which are enrolled in MTH 103C.
Query 10: List all stuids which are enrolled in ART 103A and which are not enrolled in MTH 103C.
CLASS CLASSID ART103A FACID F101 SCHED ROOM MWF9 Click to Add ENROLL FACULTY M110 HST205A + MTH101B ± MTH103C MWF11 2 F110 2 MWF11 ENROLL STUID GRADE Click to Add ART103A ART103A ART103A CSC201A CSC201A HST205A MTH101B MTH103C MTH1030 S1001 S1002 S1010 S1002 S1020 S1001 S1020 S1002 S1010 FACULTY FACID FACNAME RANK Click to Add- F101 EE F105 F110 F202 Adams Tanaka Professor Instructor Assistant Associate Professor STUDENT STUID -STUNAME MAJOR , CREDITS Click to Add H) S1002 S1010 S1013 S1015 S1020 Smith, Tom History Chin, Ann Burns, Edward Art McCarthy, Owe Math Jones, Mary Math Rivera, Jane CSCExplanation / Answer
Query 9:
We can use in Operator in to check classis is equals to these all.
select stuid from ENROLL where CLASSID IN ('ART103A' , 'MTH103C');
Query 10:
select stuid from ENROLL where CLASSID = 'ART103A' and CLASSID != 'MTH103C';