Delete table row

Hi guys, I am having trouble using DELETE function.
I need to compare two tables, if last entry in T2 equals first entry in T1, then delete first entry in T1.
The following script not working:

with T1 as(
select
ROW_NUMBER() over (order by history.timestamp asc) as rowNumber, history.timestamp, history.value
from history where Name like ‘XYZ’ AND $__timeFilter(history.timestamp)
order by history.Timestamp desc
)
,T2 as(
select
history.timestamp, history.value
from history where Name like ‘XYZ’ AND history.Timestamp BETWEEN ($__timeFrom()::date - ‘30 days’::interval) ANd $__timeFrom()
order by history.Timestamp desc
)
– if the last value in T2 is the same as first entry in T1 , then delete first entry in T1

,compareTabe as(
select (case when(select value from T1 order by T1.timestamp asc limit 1) = (select value from T2 order by T2.timestamp desc limit 1)
then (DELETE from T1 where T1.rowNumber = 1) end)
)