Skip to content
Advertisement

Average data for hours in a query

I need to obtain the average data for hours in a query but with a clause for column. I tried this:

But the result is this:

enter image description here

I need the result in differents columns but with the same hour row.

Advertisement

Answer

Do conditional aggregation :

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