skor | Listen to postgres events | GraphQL library

I have a dataset like below. I want to create the score variable with code.

Calculation of the score; Total of the entire row / Number of full columns

For example, the score calculation for row 1: (1+2+1) / 3 = 1.33

For example, the score calculation for row 2: (1+1) / 2 = 1

I want a column in sql to be the sum of 2 columns in the same table. For example: columns : score, assists, rebound While creating this table ı want score = assist + rebound value.

Goal: Develop a registration form for a website

Problem: PHP returns unexpected results to Ajax using the json_encode function (for example, it returns DUPLICATE_USERNAME when it should return DUPLICATE_EMAIL).

Code explanation / algorithm:

1. User enters their details in the registration form (username, email, etc.)
2. When submit button is clicked, the input is acquired by a PHP script (registrationProcess.php) via POST
3. A database check is run so that the username and email are available (here we suppose that they aren't)
4. PHP returns the value back to the front-end via Ajax. It returns two strings, either DUPLICATE_USERNAME or DUPLICATE_EMAIL; the function that does this is handleRegisterError($error_type)
5. Depending on the returned string, the UI of the webpage is properly changed

This function is a part of a script that gets called after the submit button is clicked.

I have multiple data on firestore. I want to receive them and show in order of small to large.

I'm trying to add data to firestore collection. Update function works good,

in my activity i have viewstub to call recycleview & other layout in recycleview i need to insert skor from radiobutton to Main activity

like this

if i choose radiobutton skor inside main layout increase

this My bind i just use text cause i don't know to send skor

I want to add a new data on my real time database. However Database deletes old data and write new data. My data scheme like that :

And I want to add a new user on rooms/roomid/users/

My code part :

When I make changes to the design screen, I cannot see it in the emulator.my goal is to fix the timers.but whatever change I make on the design screen, I can't see that change in the emulator.The timers in the emulator always look the same.

here are my codes;