CREATE TABLE hse_leatros (
learning_content_number int,
course varchar(64),
required int,
overdue int,
status int,
completion_date date
);
INSERT INTO hse_leatros VALUES (
1, 'Course 1', 1, 1, 2, '2022-12-31'
),(
1, 'Course 1', 1, 1, 2, '2022-12-31'
);
SELECT
learning_content_number,
course,
count(required) as required,
count(overdue) as overdue,
count(status) as status,
count(completion_date) as completion_date
FROM
hse_leatros
GROUP BY
learning_content_number, course;