Good morning,
I wonder if there is a way to achieve this :
I have a table with 4 fields ( id, jogoPla,Plaganha, bookie).
Is it possible to query this data and add a new column with the result for each Item of (Plaganha where bookie = pinnacle) / (plaganha where bookie=1xBet)
In this case the desired output would be this :
I wonder if there is a way to achieve this :
I have a table with 4 fields ( id, jogoPla,Plaganha, bookie).
id | jogoPla | Plaganha | bookie |
20 | item 1 | 1,42 | pinnacle |
47 | item 1 | 1,43 | 1xbet |
10 | item 2 | 2,08 | 1xbet |
21 | item 3 | 2,56 | 1xbet |
36 | item 3 | 2,71 | pinnacle |
56 | item 4 | 2,7 | pinnacle |
66 | item 5 | 1,66 | pinnacle |
98 | item 5 | 1,69 | 1xbet |
11 | item 6 | 2,15 | 1xbet |
14 | item 7 | 2,49 | pinnacle |
15 | item 7 | 2,5 | 1xbet |
Is it possible to query this data and add a new column with the result for each Item of (Plaganha where bookie = pinnacle) / (plaganha where bookie=1xBet)
In this case the desired output would be this :
id | jogoPla | Plaganha | bookie | diff |
20 | item 1 | 1,42 | pinnacle | 0,993007 |
47 | item 1 | 1,43 | 1xbet | |
10 | item 2 | 2,08 | 1xbet | |
21 | item 3 | 2,56 | 1xbet | |
36 | item 3 | 2,71 | pinnacle | 1,058594 |
56 | item 4 | 2,7 | pinnacle | |
66 | item 5 | 1,66 | pinnacle | 0,982249 |
98 | item 5 | 1,69 | 1xbet | |
11 | item 6 | 2,15 | 1xbet | |
14 | item 7 | 2,49 | pinnacle | 0,996 |
15 | item 7 | 2,5 | 1xbet |