--Первое SELECT The teacher Name has post Post with salary Salary UAH

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
--Первое
SELECT 'The teacher', Name,'has post', Post, 'with salary', Salary,'UAH', Commision, 'Процент1',(Commision/Salary)*100,'Процент2',(Salary/Commision)*100
FROM Teacher
--Второе
SELECT Faculty.Name, Subject.Name
FROM Faculty,Subject,Teacher,Sgroup
Where Post = 'доцент' AND (Curator = 11 AND Course=1)
--Третье
SELECT Department.Name
FROM Faculty, DEPARTMENT
WHERE FACULTY.FacPK = 4;
--Четвертое
SELECT Department.Name
FROM Department,Faculty,Teacher
Where Hiredate BETWEEN'20011001' AND '20011231' AND Department.Name = 'науки';
--Пятое????
SELECT Teacher.Name
FROM Teacher ,Department
WHERE Upper(Department.Name) LIKE 'Кафедра інженеріїї програмного забезпечення%' AND ChiefFK =6
--Шестое\
SELECT G1.num AS group_1_num , G1.course AS group_1_course, G2.num AS group_2_num, G2.course AS group_2_course
FROM SGroup G1, SGroup G2, Faculty F1,Faculty F2, Department D1, Department D2
WHERE g1.depfk = d1.deppk AND d1.facfk = f1.facpk AND g2.depfk = d2.deppk AND d2.facfk = f2.facpk AND F1.Fund > F2.Fund + 2000;