mySQL

Student Faculty Stuld lastName firstName major credits facID name department rank 90 Smith Chin 36 S1001 S1002 S1005 51010 Tom Ann Perry Edward History Math History Art Lee F101 F105 F110 F115 F221 Adams Tanaka Byrne Smith Smith Art CSC Math History CSC Professor Instructor Assistant Associate Professor Burns 51013 McCarthy Owen Math S1015 S1020 Jones Rivers Mary Jane Math CSC Enroll Class grade schedule room classNumber faced ART103A F101 CSC201A F105 CSC203A F105 HST205A F115 MTH101B F110 MTH1030 F110 MWF9 TuThF10 MThF12 MWF11 MTuTh9 MWF11 H221 M110 M110 H221 H225 H225 Stuld 51001 51001 S1002 S1002 S1002 S1010 S1010 S1020 S1020 Class Number ART103A HST205A ART103A CSC201A MTH103C ART103A MTH103C CSC201A MTH101B > Coo 1) Find IDs of all faculty who are assigned to the History department or who teach in room H221