sql for retrieving statistic

From: maria granholm <mago22_at_hotmail.com>
Date: 16 Jul 2003 23:47:04 -0700
Message-ID: <30b46e93.0307162247.69fa881f@posting.google.com>

HI!

I have a database collecting alarms. now I want to get statistic from the last month. and I want the average alarms to be presented per hour and after severity.

Example:

hour severity no alarms (avg for each month)

---

1

          1           50
          2           54
          3           43


          ...         ...

2
          1           62


          ...         ...

3
4
5

and is it also possible to display a Sum after each hour?

thanks!

// maria Received on Thu Jul 17 2003 - 01:47:04 CDT