Posts by Autovalor • 72 points
4 posts
-
2
votes1
answer48
viewsA: Error doing Count on Join
You must pay attention to two details in your Query: As commented, the DISTINCT is not necessary; you must replace your idea with a GROUP BY clientes.nome to aggregate the data before sorting; In…
-
0
votes1
answer37
viewsA: Doubt about Python List Code
The question was not very clear. What would be these "1st, 2nd and 3rd place"? Would be the numbers inserted in order of insertion? If yes, the following code is functional: lista = [] for x in…
-
0
votes1
answer35
viewsA: Base Bi - MYSQL
I’m not sure the question is very clear. Are the 22 databases exclusively customer information? They have the same scope? The possible answers depend on the objective of the company and the answer…
-
0
votes1
answer293
viewsA: Save data from a txt file to an entire struct or manipulate struct. C
Whereas you can already get the balance data in the variable account[i]. balance, just transform the value of this string for integer, using the function atoi(). For this, you will need a new…