List only first and last names of all full time faculty members who are teaching more than 2 courses and the total enrollment for those courses.
DROP TABLE Faculty;
CREATE TABLE Faculty
(Faculty_ID VARCHAR(2),
LastName VARCHAR(20),
FirstName VARCHAR(20),
Department VARCHAR(10),
Campus VARCHAR(10));
INSERT INTO Faculty VALUES ('1', 'Brown', 'Joe', 'Business', 'Kent');
INSERT INTO Faculty VALUES ('2', 'Smith', 'John', 'Economics', 'Kent');
INSERT INTO Faculty VALUES ('3', 'Jones', 'Sally', 'English', 'South');
INSERT INTO Faculty VALUES ('4', 'Black', 'Bill', 'Economics', 'Deerwood');
INSERT INTO Faculty VALUES ('5', 'Green', 'Gene', 'Business', 'South');
DROP TABLE COURSE;
CREATE TABLE Course
(Course_ID CHAR(2),
Ref_Number CHAR(5),
Faculty_ID VARCHAR(2),
Term Char(1),
Enrollment INTEGER,
TotRev FLOAT );
INSERT INTO Course VALUES ('1', '12345', 'a', 'A', 24, 12345.00 );
INSERT INTO Course VALUES ('2', '54321', '3', 'B', 18, 21435.00 );
INSERT INTO Course VALUES ('3', '13524', '1', 'B', 7, 1256.00 );
INSERT INTO Course VALUES ('4', '24653', '1', 'C', 29, 54421.00 );
INSERT INTO Course VALUES ('5', '98765', '5', 'A', 35, 246753.00);
INSERT INTO Course VALUES ('6', '14862', '2', 'B', 14, 9876.00);
INSERT INTO Course VALUES ('7', '96032', '1', 'C', 8, 863159.00);
INSERT INTO Course VALUES ('8', '81256', '5', 'A', 5, 98762.00);
INSERT INTO Course VALUES ('9', '64321', '2', 'C', 23, 2965.00);
INSERT INTO Course VALUES ('10','90908', 'a', 'A', 45, 91724.00);
INSERT INTO Course VALUES ('11','90908', '3', 'A', 23, 73725.00);
INSERT INTO Course VALUES ('12','90908', '3', 'A', 16, 84224.00);
INSERT INTO Course VALUES ('13','90908', 'b', 'A', 13, 42719.00);
DROP TABLE Adjuncts
CREATE TABLE Adjuncts
(Faculty_ID Char(2),
LastName VARCHAR(20),
FirstName VARCHAR(20),
Department VARCHAR(10),
Campus VARCHAR(10));
INSERT INTO Adjuncts VALUES ('a', 'Rogers', 'Aaron', 'Business', 'Kent');
INSERT INTO Adjuncts VALUES ('b', 'Manning', 'Peyton', 'Economics', 'North');Â
INSERT INTO Adjuncts VALUES ('c', 'Drew', 'Maurice', 'English', 'Cecil');
INSERT INTO Adjuncts VALUES ('d', 'Griffin', 'Robert', 'Music', 'Deerwood');
INSERT INTO Adjuncts VALUES ('e', 'Goodell', 'Roger', 'Economics', 'South');
INSERT INTO Adjuncts VALUES ('f', 'Vilma', 'Jonathan', 'Business', 'Kent');Â
