Questions tagged as 'sum'

I have a problem with the sum function in RStudio that returns the error that attachment. I know it's an error that should not occur because it's not from the code. I have already reinstalled RStudio and it still gives the same error. This erro...

Personal I need to calculate the monthly consumption of licenses used here in the company I work with. I have a table with the product (dbo.Product) , the number of licenses installed on the server (dbo.License) the date the product was in...

Good Night, I'm having a doubt I have a system that runs the following query: SELECT IDUsuario ,COUNT('TotalDeUps') as Total, FROM uploads WHERE Time >= '2018-02-20 00:00:00' AND Time < '2018-03-21 00:00:00' GROUP BY IDU...

I'm trying to do a SQL query using Join between two tables. The first table is a table that contains monthly savings values for a given project. Each time someone registers a project on the site, a PHP routine generates 12 values, one in the cur...

I have a select within my query used for sum and every time I add the GRADE field of table PA_XCPNT_EVTHST.GRADE, I get the error ORA-00907. If I remove the select grid, it works perfectly. This is the original select: ( SELECT SUM( SCORE ) FR...