Добрый,

select c.id from
(SELECT a.id, row_number () over (partition by a.id order by to_char (b.date, 'HH24MISS.MS') ) as rn
from applications a left join procedures b on a.id = b.id
and extract(year from b.date) = '2017') c where c.rn = 4

Помогите, пожалуйста, воткнуть в скрипт, чтобы на выходе вёлся подсчёт id

Пример для общего понимания ниже, но он не работает

select c.id from
(SELECT a.id, row_number () over (partition by a.id order by to_char (b.date, 'HH24MISS.MS') ) as rn
from applications a left join procedures b on a.id = b.id
and extract(year from b.date) = '2017') c where c.rn = 4
having count (c.id) >5