Python - Determine what question to ask in a quiz based on previous answers [closed]

I am trying to create a quiz which gives questions based on answers the user has previously gotten correct. I am storing the questions and User information in SQLite Databases.

Here is are sample records in the Question Database:

QUESTIONimg  QUESTIONAns  RetroScore  ModernScore  TechnologyScore  SportScore
------------------------------------------------------------------------------
image1.png   Microsoft    3           4            5                1
image2.png   Marvel       5           3            2                1

I have given each logo a score based on how much they fit into each category.

Here is a sample record in the User Database:

USERNAME  PASSWORD  RetroScore  ModernScore  TechnologyScore  SportScore
------------------------------------------------------------------------
John      John123   0           0            0                0

My plan is to have the 'Score' columns increment as the user gets a question correct. For example if the user gets a question which has a TechnologyScore of 5, their TechnologyScore in the User Database will increment by that amount.

These scores will then be used to decide what question the user should get asked next, making the quiz increasingly harder as they are tested on their weaknesses.

I have experimented with Python's native random library using random.choices however I feel as if the 'Weighted odds' can be used to a great detail. As this allows a chance at the user getting asked a question which they have strong knowledge on, however it would be more unlikely.

My end-goal is to have the next question be determined by comparisons between what the categories the user has a high score in and what they have a low score in.

I am unsure how to filter through the logo database to find a suitable next question.