INSERT INTO teacher(
    login, password)
    VALUES ('Teacher1', '123321');
INSERT INTO teacher(
    login, password)
    VALUES ('Teacher2', 'qwerty');

INSERT INTO test(
    name, teacher_id)
    VALUES ('Test1', (select teacher_id from teacher where teacher.login = 'Teacher1'));
INSERT INTO test(
    name, teacher_id)
    VALUES ('Test2', (select teacher_id from teacher where teacher.login = 'Teacher1'));

INSERT INTO test_execution(
    test_id, date, running)
    VALUES ((select test_id from test where test.name = 'Test1'), current_timestamp, false);

INSERT INTO question(
    test_id, type, text, image, answer1, answer2, answer3, answer4, right_answer)
    VALUES ((select test_id from test where test.name = 'Test1'), 1, 'Question1', NULL, 'ans1', 'ans2', 'ans3', 'ans4', 4);
INSERT INTO question(
    test_id, type, text, image, answer1, answer2, answer3, answer4, right_answer)
    VALUES ((select test_id from test where test.name = 'Test1'), 1, 'Question2', NULL, 'ans1', 'ans2', 'ans3', 'ans4', 2);
INSERT INTO question(
    test_id, type, text, image, answer1, answer2, answer3, answer4, right_answer)
    VALUES ((select test_id from test where test.name = 'Test1'), 2, 'Question3', NULL, 'ans1', 'ans2', '', '', 1);

INSERT INTO result(
    student_name, execution_id, question_id, answer)
    VALUES ('Vasya', 1, (select question_id from question where question.text = 'Question1'), 4);
INSERT INTO result(
    student_name, execution_id, question_id, answer)
    VALUES ('Vasya', 1, (select question_id from question where question.text = 'Question2'), 1);
INSERT INTO result(
    student_name, execution_id, question_id, answer)
    VALUES ('Vasya', 1, (select question_id from question where question.text = 'Question3'), 1);
INSERT INTO result(
    student_name, execution_id, question_id, answer)
    VALUES ('Petya', 1, (select question_id from question where question.text = 'Question1'), 1);
INSERT INTO result(
    student_name, execution_id, question_id, answer)
    VALUES ('Petya', 1, (select question_id from question where question.text = 'Question2'), 2);
INSERT INTO result(
    student_name, execution_id, question_id, answer)
    VALUES ('Petya', 1, (select question_id from question where question.text = 'Question3'), 2);