Posts by Gabriel Anadinho • 1 point
3 posts
-
0
votes0
answers28
viewsQ: Select with field of the same name between two tables without connection however approximate values
I have the 3 tables, 'users_teste', 'nps' and 'product', the product table has no relation with the other 2 tables, I need to perform a search comparing the request of the table 'nps' with the…
-
-2
votes2
answers20
viewsA: Grouping datatime in selects and summing the elements of the search per day to perform a comparison of the days of a given month
I put it this way and it worked, vlw too! select count(solicitacao) as emissões, DATE(dataSituacao) from certificado where status like 'EMITIDO%' and DATE(dataSituacao) BETWEEN '2020-10-01' and…
-
-1
votes2
answers20
viewsQ: Grouping datatime in selects and summing the elements of the search per day to perform a comparison of the days of a given month
I’m using the type datatime and trying to perform a select that counts emissions day-to-day to mount a comparison chart of the days of a given month. However, when grouping the dates it is returning…