By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table online_plan (
id integer primary key,
squad integer,
status varchar(10),
date varchar(10)
);
insert into online_plan values(1, 10, 'closed', '15.12.2019')
1 rows affected
SELECT *
FROM online_plan
WHERE
CONVERT(datetime, date, 104) >= GETDATE()
AND squad = '10'
AND status !='opened'
| id | squad | status | date |
|---|---|---|---|
| 1 | 10 | closed | 15.12.2019 |