MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `level_quiz` (
  `id` int(11) NOT NULL,
  `level_title` varchar(50) NOT NULL,
  `quiz_desc` varchar(200) NOT NULL,
  `overall_quest` varchar(250) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `student_points` (
  `student_no` int(9) NOT NULL,
  `level_id` int(11) NOT NULL,
  `points` int(3) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `level_quiz` (`id`, `level_title`, `quiz_desc`, `overall_quest`) VALUES
(1, 'Sets', 'The purpose of this challenge is to help you become completely familiar with how to write certain kinds of sets, and how to perform the standard operations on actual sets. ', 'Suppose we have three sets of numbers A, B and C, which are defined as follows:\r\nA = { 1, 10, 7, 3, 5, 2 }\r\nB = { 5, 8, 6, 7, 4 }\r\nC = { 7, 1, 8 }'),
(2, 'sequences', 'sequences desc', 'overall question 2'),
(3, 'Propositional Logic', 'logic desc', 'overall quest logic '),
(4, 'Predicate Logic - Sets', 'predicate desc 1', 'predicase quest 1');

INSERT INTO `student_points` (`student_no`, `level_id`, `points`, `timestamp`) VALUES
(12345678, 1, 80, '2021-01-15 16:07:43'),
(12345678, 2, 25, '2021-01-13 17:15:10'),
(12345678, 3, 90, '2021-01-17 22:41:55'),
(12345678, 4, 90, '2021-01-17 22:41:55'),
(40145489, 1, 85, '2021-01-14 21:50:58'),
(40204123, 1, 80, '2021-01-12 15:37:11'),
(40204123, 2, 75, '2021-01-12 15:38:06'),
(40204123, 3, 30, '2021-01-13 22:13:13'),
(40213894, 1, 90, '2021-01-14 21:52:00'),
(40213894, 2, 95, '2021-01-17 22:42:50'),
(40213894, 4, 100, '2021-01-17 22:42:50'),
(40283947, 1, 57, '2021-01-14 21:50:14'),
(40334891, 1, 95, '2021-01-14 21:54:25'),
(40829379, 1, 70, '2021-01-14 21:50:38'),
(45216227, 1, 97, '2021-01-16 19:05:16');

Records: 4  Duplicates: 0  Warnings: 0



Records: 15  Duplicates: 0  Warnings: 0


SELECT * FROM level_quiz LEFT JOIN student_points ON level_quiz.id = student_points.level_id WHERE student_points.student_no = 40204123 OR student_points.student_no IS NULL


id
level_title
quiz_desc
overall_quest
student_no
level_id
points
timestamp


1
Sets
The purpose of this challenge is to help you become completely familiar with how to write certain kinds of sets, and how to perform the standard operations on actual sets.
Suppose we have three sets of numbers A, B and C, which are defined as follows:
A = { 1, 10, 7, 3, 5, 2 }
B = { 5, 8, 6, 7, 4 }
C = { 7, 1, 8 }
40204123
1
80
2021-01-12 15:37:11

2
sequences
sequences desc
overall question 2
40204123
2
75
2021-01-12 15:38:06

3
Propositional Logic
logic desc
overall quest logic
40204123
3
30
2021-01-13 22:13:13

id	level_title	quiz_desc	overall_quest	student_no	level_id	points	timestamp
1	Sets	The purpose of this challenge is to help you become completely familiar with how to write certain kinds of sets, and how to perform the standard operations on actual sets.	Suppose we have three sets of numbers A, B and C, which are defined as follows: A = { 1, 10, 7, 3, 5, 2 } B = { 5, 8, 6, 7, 4 } C = { 7, 1, 8 }	40204123	1	80	2021-01-12 15:37:11
2	sequences	sequences desc	overall question 2	40204123	2	75	2021-01-12 15:38:06
3	Propositional Logic	logic desc	overall quest logic	40204123	3	30	2021-01-13 22:13:13