How is hourly pay calculated on Upwork?

Question

Python

How is the hourly work on the order taken generally calculated? Do I need to put some kind of program like motivateclock that counts how much time I spent in photoshop or android studio for example? And if I opened the desired program and do nothing in it, or, for example, do not follow the project that I took? How is time taken into account specifically for the project taken and are there any fines and other sanctions for tricks, delays or inactivity on the project? How does it even work? For the first time, I'm seriously looking at upwork.

Answer 1

something like that:

WITH ord AS (
    SELECT n_a, count(*) cn FROM photos WHERE id in ({_ids_string}) GROUP BY n_a 
)
SELECT id, id_sys, n, photos.n_a, source 
    FROM photos 
    JOIN ord ON photos.n_a=ord.n_a
    WHERE id in ({_ids_string})
    ORDER BY cn DESC

Answer 2

See GROUP BYand ORDER BY.
For example, this table:

+----+-------+
| id | value |
+----+-------+
|  1 | alpha |
|  2 | delta |
|  3 | beta  |
|  4 | gamma |
|  5 | beta  |
|  6 | beta  |
|  7 | alpha |
|  8 | beta  |
+----+-------+

SQL:

SELECT `value` , COUNT( * ) AS `cnt`
FROM `testtable2`
GROUP BY `value`
ORDER BY `cnt` DESC

Result:

+-------+-----+
| value | cnt |
+-------+-----+
| beta  |   4 |
| alpha |   2 |
| delta |   1 |
| gamma |   1 |
+-------+-----+

Do it yourself by analogy.

Answer 3

This is a classic use case for window functions: https://postgrespro.ru/docs/postgresql/11/tutorial...

Answer 4

Upwork has its own time tracker.
Install, run and work. Once every 10 minutes, he takes screenshots and sends them to the server, everything is visible there.
They also track the number of clicks / keystrokes.
The customer sees all this and can either accept the watch or appeal against individual watches.
You can delete individual screenshots uploaded to the server, but then this time will not be paid. (10 min each screenshot).

Answer 5

the tracker from upwork removes screenshots and activity from the keyboard and mouse,
then the customer looks at it
if he sees that you are worthless, judging by your questions, the employee disputes the hours worked,
respectively, arbitration if he sees that you did not work, he simply removes this time from payment immediately