-- SQL workarea

-- 2/26

tee 2025_2_26_sql_log.txt

UPDATE Student
SET major = 'ITEC'
WHERE StuId = 100000;

-- All students will be majoring in CSCI
UPDATE Student
SET major = 'CSCI';

-- operators:
-- student with credits in a range.
SELECT DISTINCT *
FROM Student
WHERE ach BETWEEN 30 AND 70;

-- a
SELECT DISTINCT *
FROM Student
WHERE ach BETWEEN 35 AND 66;

-- b
SELECT DISTINCT *
FROM Student
WHERE ach >= 35 
AND ach <= 66;




SELECT s.stuId, d.deptCode, d.deptName AS department
FROM Student AS s INNER JOIN department AS d ON (s.major = d.deptCode);


SELECT s.stuId, d.deptCode, d.deptName AS department
FROM Student AS s LEFT JOIN department AS d ON (s.major = d.deptCode);


SELECT s.stuId, d.deptCode, d.deptName AS department
FROM department AS d RIGHT JOIN  Student AS s  ON (s.major = d.deptCode);

-- subqueries in the WHERE course
-- students not enrolled in any class.
SELECT DISTINCT *
FROM student AS s
WHERE s.stuId NOT IN (SELECT DISTINCT e.stuID FROM enroll AS e);