SELECT   *
    FROM   (  SELECT   60 * (EXTRACT (HOUR FROM INSERTED_DATE) - 12)
                       + EXTRACT (MINUTE FROM INSERTED_DATE)
                          AS MINUTE,
                       COUNT (E.ID_EVENT) / 60 AS FRAMESPERSECONDE
                FROM   EVENT E
               WHERE   INSERTED_DATE >
                          TO_TIMESTAMP ('23122011 12:00:00',
                                        'DDMMYYYY HH24:MI:SS')
            GROUP BY   EXTRACT (HOUR FROM INSERTED_DATE),

SELECT   INSERTED_DATE
  FROM   (  SELECT   *
              FROM   EVENT E
          ORDER BY   E.INSERTED_DATE DESC)
 WHERE   ROWNUM < 100;