UPDATE Enroll
SET grade = 'A'
WHERE stuId = 100001
AND classId = 10000;

UPDATE Enroll
SET grade = NULL
WHERE stuId = 100001
AND classId = 10000;

CREATE TABLE IF NOT EXISTS Faculty_more_reg_1 (
    facId       INT NOT NULL,
    fname       VARCHAR(20) NOT NULL,
    lname       VARCHAR(20) NOT NULL,
    deptCode    VARCHAR(4) NOT NULL,
    deptName    VARCHAR(30),
    `rank`      VARCHAR(25),
    CONSTRAINT Faculty_facId_pk PRIMARY KEY (facId),
    CONSTRAINT Faculty_more_reg_deptCode_fk FOREIGN KEY (deptCode) 
        REFERENCES Department(deptCode));
        
CREATE TEMPORARY TABLE IF NOT EXISTS Faculty_more (
    facId       INT NOT NULL,
    fname       VARCHAR(20) NOT NULL,
    lname       VARCHAR(20) NOT NULL,
    deptCode    VARCHAR(4) NOT NULL,
    deptName    VARCHAR(30),
    `rank`      VARCHAR(25),
    CONSTRAINT Faculty_facId_pk PRIMARY KEY (facId));
    
INSERT INTO FACULTY_More VALUES
   ('1011','Paul','Smith','CSCI','Computer Science', 'Professor'),
   ('1012','Mary','Tran','CSCI','Computer Science', 'Associate Professor'),
   ('1013','David','Love','CSCI','Computer Science', 'Associate Professor'),
   ('1014','Sharon','Mannes','CSCI','Computer Science', 'Assistant Professor'),
   ('1015','Daniel','Kim','CINF','Computer Information Systems', 'Professor'),
   ('1016','Andrew','Byre','CINF','Computer Information Systems', 'Associate Professor'),
   ('1017','Deborah','Gump','ITEC','Information Technology','Professor'),
   ('1018','Art','Allister','ARTS','Arts','Assistant Professor'),
   ('1019','Benjamin','Yu','ITEC','Information Technology','Lecturer'),
   ('1020','Katrina','Bajaj','ENGL','English','Lecturer'),
   ('1021','Jorginlo','Neymar','ACCT','Account','Assistant Professor');

SELECT DISTINCT f.facId,
    f.fname, f.lname, f.deptCode,
    d.deptName AS department,
    f.`rank`
FROM faculty f INNER JOIN department d
    ON (f.deptCode = d.deptCode);

INSERT INTO faculty_more
SELECT DISTINCT f.facId,
    f.fname, f.lname, f.deptCode,
    d.deptName AS department,
    f.`rank`
FROM faculty f INNER JOIN department d
    ON (f.deptCode = d.deptCode);
    
 CREATE TABLE IF NOT EXISTS Faculty_more_2 (
    facId       INT NOT NULL,
    fname       VARCHAR(20) NOT NULL,
    lname       VARCHAR(20) NOT NULL,
    deptCode    VARCHAR(4) NOT NULL,
    deptName    VARCHAR(30),
    `rank`      VARCHAR(25),
    CONSTRAINT Faculty_facId_pk PRIMARY KEY (facId));   
    
 INSERT INTO Faculty_more_2
 SELECT * FROM faculty_more;