By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TABLE1
(
REFERENCE varchar(20),
PROPERTYADDRESS varchar(20),
DATE datetime,
RATING int
);
insert into TABLE1
values
('adef', 'PROPERTY12', '2022-12-08', 70),
('pout', 'PROPERTY12', '2022-12-16', 90),
('mhef', 'PROPERTY17', '2023-01-02', 25),
('jygh', 'PROPERTY17', '2023-01-09', 70),
('boyt', 'PROPERTY22', '2022-10-05', 64),
('qepl', 'PROPERTY22', '2022-10-25', 67);
Records: 6 Duplicates: 0 Warnings: 0
select PROPERTYADDRESS
from TABLE1
where RATING <= 50
and PROPERTYADDRESS in (
select PROPERTYADDRESS
from TABLE1
where RATING >= 70
);
| PROPERTYADDRESS |
|---|
| PROPERTY17 |