How to create statistics?

Question

Database design

Hello, how to create this in the database?

spoiler

Will there be one statistics table in the database with the number of points, awards, achievements, lessons learned, etc.?
Or do you need to create a table for each type: points - points table, awards - awards, lessons learned - completed_lesson, etc.?

Answer 1

the first thing that came to mind.
Table "statistics" with UsedID, and statistical columns. Initialization to 0. Only 1 row in DB.
The user starts the lesson - the timer turns on, the user finishes the lesson - the timer ends, the time difference goes to the column with hours, the calculated achievements are summed up and updated in the required columns. Or after each achievement, there is the same update. It's up to you to decide.