Node Updates in Last Minute.sql

select
   processid,
    nodeid as "NodeId", 
    DATEDIFF('SECOND', DATE '1970-01-01', log_date) AS "sec",
    count(nodeid) as "total"  
from 
    NodeInstanceLog
where
    datediff('SECOND', log_date, current_timestamp) < 60 
group by 
     processid,
    nodeid,
    DATEDIFF('SECOND', DATE '1970-01-01', log_date)
order by 
    DATEDIFF('SECOND', DATE '1970-01-01', log_date)
DESC