我正在尝试从试探性2获取总行数，但错误为“关系”试探性2“不存在”

select
  (
    select count(*) from tempTable2
    where (EXTRACT(EPOCH FROM (maxdailylog - mindailylog))/3600)>4.5
  ) as totalHadir,
  (
    select count(*) from tempTable2
    where (EXTRACT(EPOCH FROM (maxdailylog - mindailylog))/3600)<4.5
  ) as absenTidakKomplit
from
  (
    select LogHari, mindailylog, maxdailylog, count(LogHari) as jumlahLog from(
       select waktuabsen::date as LogHari,
         min(waktuabsen) over (partition by userid, waktuabsen::date) as mindailylog,
         max(waktuabsen) over (partition by userid, waktuabsen::date) as maxdailylog,
         dense_rank() over (order by waktuabsen::date) as grouplistno
       from sdm.tabsen
       where userid=866 and waktuabsen >= '2020-03-01T00:00:00' and waktuabsen < '2020-03-31T00:00:00'
      ) as tempTable
      group by grouplistno, LogHari, mindailylog, maxdailylog
  ) as tempTable2