SQL Queries

Historico

select to_char(STARTTIME, 'YYYY') as YEAR1, count(1) as CNT
from wfinstance 
where active=0
and deletable=1
group by to_char(STARTTIME, 'YYYY')
order by to_char(STARTTIME, 'YYYY')

result:

YEAR1	CNT
2017	536611
2018	12263485
2019	17314752
2020	10712313
2021	20238022

Ver também