By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename (`ID` VARCHAR(1), `Trending_Date` DATE, `Views` INTEGER);
INSERT INTO tablename (`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 tablename
GROUP BY id
HAVING COUNT(*) = COUNT(DISTINCT Views)
AND GROUP_CONCAT(Views ORDER BY Views DESC) = GROUP_CONCAT(Views ORDER BY Trending_Date)
| ID |
|---|
| A |
SELECT *
FROM tablename
WHERE id IN (
SELECT ID
FROM tablename
GROUP BY id
HAVING COUNT(*) = COUNT(DISTINCT Views)
AND GROUP_CONCAT(Views ORDER BY Views DESC) = GROUP_CONCAT(Views ORDER BY Trending_Date)
)
| ID | Trending_Date | Views |
|---|---|---|
| A | 2021-01-03 | 10 |
| A | 2021-02-05 | 9 |