SQLize Online / PHPize Online  /  SQLtest Online

create table TEST (NAME varchar(64), BIRTHDATE date); insert into TEST values ('123', to_date('1990-02-03', 'YYYY-MM-DD')); insert into TEST values ('456', to_date('1999-02-03', 'YYYY-MM-DD')); select * from TEST; create or replace view TEMP_COUNT1 as SELECT tbl."ID_CLIENT", CASE WHEN EXTRACT(DAY FROM BIRTHDATE) IN (5, 12, 19, 26) AND 'false'='false' THEN 1 WHEN EXTRACT(DAY FROM BIRTHDATE) NOT IN (5, 12, 19, 26) AND 'false'='false' THEN 0 ELSE 1 END AS IS_CONTROL_GROUP FROM CM_FIS.TEMP_93983 tbl; SELECT COUNT(*) FROM CM_FIS.TEMP_COUNT1 WHERE "IS_CONTROL_GROUP" = 0;