СКЬЮЭЛЬ помощь с информатикой 107

Скюэль практическая по информатике key

12
tel_otd text,
13
FOREIGN KEY (id_spec) REFERENCES specialties (spec)):
14 CREATE TABLE teachers
(id_prepod integer PRIMARY KEY AUTOINCREMENT,
15
id otd integer,
16
surname text,
17
name text,
18
fullname text,
19
post text,
20
stage integer,
21
FOREIGN KEY (id_otd) REFERENCES departmentsid_otd));
22
CREATE TABLE groups
(id_group integer PRIMARY KEY AUTOINCREMENT,
23
id otd integer,
24
num_group text,
25
year integer,
26
quantity integer,
27
FOREIGN KEY (id_otd) REFERENCES departmentsid_otd));
28
CREATE TABLE students (id_stud integer PRIMARY KEY AUTOINCREMENT,
29
id group integer,
30
surname text,
31
name text,
32
fullname text,
33
adress text,
34
birthday integer,
35
FOREIGN KEY (id_group) REFERENCES groups(id_group));
CREATE TABLE disciplines (id_subject integer PRIMARY KEY AUTOINCREMENT, id_otd integer, subject text, hours integer, control text,
FOREIGN KEY (id_otd) REFERENCES departments(id_otd));

(41)

INSERT INTO students (surname, name, fullname, adress, birthday) VALUES ('a', 'a', 'fullname', 'adress',
'birthday'):
44 INSERT INTO students (surname, name, fullname, adress, birthday) VALUES ('6',
'6', 'fullname',
"adress',
"birthday'):
45
INSERT INTO students (surname, name, fullname, adress, birthday) VALUES ('',
'в',
"fullname',
'adress',
'birthday');
46
47
INSERT INTO teachers (surname, name, fullname, post, stage) VALUES ('в',
'B', 'fullname',
"post', 4);
48
INSERT INTO teachers (surname,
name, fullname, post, stage) VALUES ('в',
'в',
"fullname',
'post', 3):
49
INSERT INTO teachers (surname,
name,
fullname, post, stage) VALUES ('E', 'E'I
''fullname',
'post', 1);

49
50 пусто

INSERT INTO groups (num_group, year, quantity) VALUES (20, 2024, 'bre');
52g
INSERT INTO groups (num_group, year, quantity) VALUES (20, 2025,
"bre');
53
INSERT INTO groups (num group, [year, quantity) VALUES (20, 2026, 'bre');
54
55
INSERT INTO disciplines (subject, hours, control) VALUES ('Информатика", 1, 'f');
56
INSERT INTO disciplines (subject, hours, control) VALUES ('5pe", 1, 'f*);
57
INSERT INTO disciplines (subject, hours, control) VALUES ('Русский, 3, 'f*);
58
59
SELECT surname, name, fullname FROM students ORDER BY surname DESC;
60
61 SELECT surname, name, fullname, post, stage FROM teachers WHERE stage<2;
62
SELECT id group, id_otd, num group, year, quantity FROM groups WHERE year == 2024;
64
1. SELECT id otd, subject, MIN(hours), control FROM disciplines;
2. SELECT id _otd, subject, MAX(hours), control FROM disciplines;
67
68 SELECT AVG(stage) AS average_stage FROM teachers;
69
70 SELECT CONCAT(subject,'', hours) A5 Учебная программа
FROM disciplines;