SQLSQLSQLSQL

            CONSTRAIT employess
            FOREIGN KEY (deptID)
            REFERENCES Employee(id)
            ON DELETE CASCADE
            ON UPDATE CASCADE,

            CONSTRAIT pr_key
            PRIMARY KEY (emplID,deptID) ON CONFLICT ROLLBACK
            );

INSERT INTO Hired VALUES(101,1)
INSERT INTO Hired VALUES(102,3,15000)
INSERT INTO Hired VALUES(103,3,28000)
INSERT INTO Hired VALUES(104,2,32000)
INSERT INTO Hired VALUES(105,3,21000)

SELECT * FROM Department WHERE location LIKE 'Par%';

SELECT * FROM Employee WHERE id in
(SELECT emplID FROM Hired WHERE deptID IS 3);

SELECT * FROM Employee WHERE id in
(SELECT emplID FROM Hired WHERE deptID in
(SELECT id FROM Department WHERE name LIKE 'Sal%'));

CREATE View TechEmpl(id,name,title) AS
SELECT id,name,title FROM Employee WHERE id in
(SELECT emplID FROM Hired WHERE deptID IS 3);

CREATE View Salary (salary,name,department) AS
SELECT Hired.salary, Employee.name, Department.name
FROM Employee, Hired,Department
WHERE Employee.id = Hired.emplID AND Hired,deptID = Department.id
ORDER BY Hired.salary;

SELECT * FROM TechEmpl ORDER BY name ASC;

SELECT * FROM Salary ORDER BY salary DESC;