1/110
theory + syntax
DATE / TIME / DATETIME format
DATE format - 'YYYY-MM-DD', e.g. '2024-03-23'
TIME format - 'hh:mm:ss', e.g. '23:05:59'
DATETIME format - 'YYYY-MM-DD hh:mm:ss', e.g. '2024-03-23 23:05:59'
logical operators
AND (&&), OR (||), NOT (!), XOR

insert one student (all columns)
INSERT INTO students VALUES ('Katerina', 17, 5.50);
insert several students
INSERT INTO students VALUES ('Katerina', 17, 5.50), ('John', 16, 6.00);
change John’s age to 17
UPDATE students SET age = 17 WHERE name = 'John';
delete John
DELETE FROM students WHERE name = 'John';