Postgresql subquery w between

CREATE TABLE synchronizations (synchronization TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP)

SELECT synchronization FROM synchronizations ORDER BY synchronization DESC FETCH FIRST 2 ROWS ONLY

CREATE TABLE emails (addressee TEXT NOT NULL, title TEXT NOT NULL, content TEXT NOT NULL, queued TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP)

SELECT * FROM emails WHERE queued BETWEEN ... ?

SELECT * FROM emails WHERE queued BETWEEN (SELECT synchronization FROM synchronizations ORDER BY synchronization DESC FETCH FIRST 2 ROWS ONLY)

SELECT emails.* FROM emails INNER JOIN (SELECT MIN(synchronization) AS date_start, MAX(synchronization) AS date_end FROM (SELECT synchronization FROM synchronizations ORDER BY synchronization DESC FETCH FIRST 2 ROWS ONLY) AS t1) AS t2 ON emails.queued BETWEEN date_start AND date_end

with cte as (select s.synchronization date_end, 
                    lead(s.synchronization,1) over (order by s.synchronization desc) start_date 
               from synchronizations s
              order by s.synchronization desc
              limit 1)
select e.* from cte
  join emails e on date_trunc('seconds', e.queued::timestamp) between date_trunc('seconds', cte.start_date::timestamp) and date_trunc('seconds', cte.date_end::timestamp) 

select * from emails where (
select quequed between lead(synchronization) over(ORDER BY synchronization DESC) and synchronization  from synchronizations ORDER BY synchronization DESC FETCH FIRST 1 ROWS ONLY
)