By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab1 (
`ID` VARCHAR(1),
`Trending_Date` VARCHAR(10),
`Views` INTEGER
);
INSERT INTO tab1
(`ID`, `Trending_Date`, `Views`)
VALUES
('A', '2021-01-03', '10'),
('B', '2020-10-30', '8'),
('A', '2021-02-05', '9'),
('B', '2020-11-02', '11');
select id
from
(
select id,trending_date,views,max(trending_date)over(partition by id)maxtdate,
min(trending_date)over(partition by id)mintdate
from tab1
)t
group by id
having max(case when trending_date=maxtdate then views end) < max(case when trending_date=mintdate then views end)
| id |
|---|
| A |
select id
from
(
select id,trending_date,views,(select max(trending_date)from tab1 t2 where t1.id=t2.id)maxtdate,
(select min(trending_date)from tab1 t2 where t1.id=t2.id)mintdate
from tab1 t1
)t
group by id
having max(case when trending_date=maxtdate then views end) < max(case when trending_date=mintdate then views end)
| id |
|---|
| A |