sqlquery1.sql

to study the example of creation of tables, formative DB, and filling with their information. Using

					id_subject smallint REFERENCES Subject_names ,
					id_mark tinyint REFERENCES Mark_names)
insert into Mark (id_stud,id_subject,id_mark) values ('1','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('1','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('1','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('1','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('1','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('1','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('1','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('1','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('1','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('1','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('2','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('2','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('2','13','6')
insert into Mark(id_stud,id_subject,id_mark) values ('2','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('2','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('2','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('2','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('2','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('2','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('2','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('3','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('3','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('3','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('3','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('3','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('3','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('3','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('3','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('3','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('3','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('4','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('4','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('4','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('4','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('4','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('4','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('4','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('4','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('4','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('4','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('5','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('5','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('5','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('5','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('5','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('5','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('5','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('5','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('5','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('5','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('6','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('6','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('6','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('6','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('6','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('6','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('6','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('6','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('6','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('6','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('7','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('7','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('7','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('7','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('7','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('7','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('7','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('7','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('7','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('7','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('8','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('8','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('8','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('8','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('8','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('8','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('8','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('8','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('8','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('8','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('9','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('9','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('9','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('9','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('9','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('9','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('9','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('9','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('9','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('9','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('10','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('10','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('10','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('10','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('10','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('10','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('10','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('10','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('10','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('10','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('11','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('11','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('11','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('11','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('11','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('11','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('11','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('11','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('11','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('11','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('12','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('12','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('12','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('13','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('13','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('13','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('13','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('13','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('13','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('13','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('14','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('14','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('14','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('14','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('14','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('14','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('14','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('14','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('14','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('14','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('15','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('15','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('15','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('15','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('15','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('15','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('15','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('15','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('15','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('15','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('16','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('16','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('16','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('16','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('16','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('16','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('16','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('16','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('16','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('16','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('17','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('17','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('17','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('17','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('17','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('17','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('17','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('17','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('17','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('17','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('18','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('18','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('18','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('18','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('18','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('18','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('18','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('18','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('18','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('18','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('19','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('19','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('19','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('19','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('19','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('19','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('19','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('19','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('19','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('19','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('20','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('20','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('20','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('20','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('20','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('20','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('20','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('20','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('20','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('20','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('21','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('21','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('21','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('21','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('21','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('21','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('21','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('21','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('21','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('21','10','5')

insert into Mark (id_stud,id_subject,id_mark) values ('22','11','4')
insert into Mark (id_stud,id_subject,id_mark) values ('22','12','5')
insert into Mark (id_stud,id_subject,id_mark) values ('22','13','6')
insert into Mark (id_stud,id_subject,id_mark) values ('22','14','7')
insert into Mark (id_stud,id_subject,id_mark) values ('22','15','4')
insert into Mark (id_stud,id_subject,id_mark) values ('22','16','5')
insert into Mark (id_stud,id_subject,id_mark) values ('22','17','6')
insert into Mark (id_stud,id_subject,id_mark) values ('22','18','7')
insert into Mark (id_stud,id_subject,id_mark) values ('22','19','5')
insert into Mark (id_stud,id_subject,id_mark) values ('22','20','5')

insert into Mark (id_stud,id_subject,id_mark) values ('23','1','4')
insert into Mark (id_stud,id_subject,id_mark) values ('23','2','5')
insert into Mark (id_stud,id_subject,id_mark) values ('23','3','6')
insert into Mark (id_stud,id_subject,id_mark) values ('23','4','7')
insert into Mark (id_stud,id_subject,id_mark) values ('23','5','4')
insert into Mark (id_stud,id_subject,id_mark) values ('23','6','5')
insert into Mark (id_stud,id_subject,id_mark) values ('23','7','6')
insert into Mark (id_stud,id_subject,id_mark) values ('23','8','7')
insert into Mark (id_stud,id_subject,id_mark) values ('23','9','5')
insert into Mark (id_stud,id_subject,id_mark) values ('23','10','5')