with cte as(
  select
    t1.id,
    t1.data->>'route_id' route_id ,
    t2.name 
  from
    tbl.logins t1
      inner join
    tbl.routes t2
    on t2.id = (t1.data->>'route_id')::integer 
  group by
    t1.id,
    t1.data->>'route_id',
    t2.name 
)

select
  t2.name,
  t1."time",
  count(t1."time") 
from
  tbl.setting_price_timesheets t1
    inner join
  cte t2
    on t2.id = t1.work_login_id
    and t1.enabled
    and t1."time" is not null
        
group by
  t2.name,
  t1."time"    
;