Skip to content
Advertisement

Writing SQL query : getting the average value per minute

I want to make a query getting the average created value per minute. I don’t come up with any idea but using subquery like below. Would there be any other ways using only one query (without subquery)

Advertisement

Answer

The average created value could be calculated as:

That is, divide the total by the number of minutes.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement