Help with Data Selection pls

Need help Database
1

I have a Type AnsweredQuestions with User, Question (type) and Answer (field). For example:

User Question Answer
1 1 0
1 2 1
1 3 1
2 1 0
2 2 0
3 1 0
3 2 0
3 3 1
I need to find users with a number of matched answers to the current user (User1) so the result should look like:
User Count of the same answers to the same questions:
2 1
3 2

Please help

2

set a datatype to be answers with datafields for answer 1, 2, 3 ( if you only have 3 questions ) and a datafield of users which links to the user data type.

set a datatype of user with datafield of “answers” which is a reference to the datatype of answers.

You should search the forum for “relational database” also use google for that search to learn more about database structure. Also use any tutorials on the bubble site and other learning resources to learn more about database structure and search queries etc.