quizapp/question.sql at master · VannHungg/quizapp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
CREATE TABLE "question" (
    "id" SERIAL PRIMARY KEY,
    "category" VARCHAR(25),
    "difficulty_level" VARCHAR(25),
    "option1" VARCHAR(255),
    "option2" VARCHAR(255),
    "option3" VARCHAR(255),
    "option4" VARCHAR(255),
    "question_title" VARCHAR(255),
    "correct_answer" VARCHAR(255)
);

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('Geography', 'Easy', 'What is the capital of France?', 'Paris', 'London', 'Rome', 'Berlin', 'Paris');

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('Literature', 'Medium', 'Who wrote the novel "Moby Dick"?', 'Herman Melville', 'Mark Twain', 'Charles Dickens', 'Leo Tolstoy', 'Herman Melville');

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('Math', 'Hard', 'What is the square root of 16?', '4', '8', '12', '16', '4');

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('Science', 'Easy', 'What is the name of the largest planet in the solar system?', 'Jupiter', 'Saturn', 'Uranus', 'Neptune', 'Jupiter');

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('History', 'Medium', 'What was the name of the first world war?', 'World War I', 'World War II', 'The Great War', 'The War to End All Wars', 'World War I');

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('History', 'Easy', 'Mel is mother is in ........ hospital, so we went to visit her last night.', 'a', 'the', 'an', 'Ø', 'Ø');

INSERT INTO question (category, difficulty_level, question_title, option1, option2, option3, option4, correct_answer)
VALUES ('History', 'Easy', 'Mel is on ........ table, so we went to visit her last night.', 'a', 'the', 'an', 'Ø', 'Ø');


SELECT *FROM QUESTION