L11ID6588033

USE tinycollege;

/* Q1 /
INSERT INTO professor (EMP_NUM, EMP_FNAME, EMP_LNAME, EMP_DOB, DEPT_CODE) VALUES (101, "Charles", "Xavier", "1975-05-04 00:00:00", "CIS");
/ Q2 /
UPDATE professor SET PROF_EXTENSION = "0077" WHERE EMP_NUM = 101;
/ Q3 */
DELETE FROM professor WHERE EMP_NUM = 101;

/* Q4 /
SELECT * FROM student;
/ Q5 /
SELECT DISTINCT COURSE_CODE FROM class;
/ Q6 /
SELECT EMP_FNAME, EMP_LNAME, DEPT_CODE FROM professor WHERE DEPT_CODE = "CIS";
/ Q7 /
SELECT EMP_FNAME, EMP_LNAME FROM professor WHERE EMP_FNAME LIKE '%M%' AND EMP_LNAME LIKE '%M%';
/ Q8 */
SELECT STU_FNAME, STU_LNAME, DEPT_CODE FROM student WHERE DEPT_CODE IN ('ENG', 'ART', 'SOC', 'HIST');

/* Q9 */
SELECT COURSE_CODE, COURSE_NAME, 250 * CRS_CREDIT AS 'TUITION FEE', DEPT_CODE
FROM course
WHERE COURSE_NAME
LIKE 'Intro.%';

/* Q10 */
SELECT DISTINCT COURSE_CODE, CLASS_ROOM FROM class WHERE CLASS_ROOM LIKE 'KLR%' AND CLASS_CODE BETWEEN 20000 AND 30000;