SQLize Online / PHPize Online  /  SQLtest Online

create table TEST_TEMP (NAME varchar(64), BIRTHDATE date); insert into TEST_TEMP values ('123', to_date('1990-01-03', 'YYYY-MM-DD')); insert into TEST_TEMP values ('456', to_date('1999-02-03', 'YYYY-MM-DD')); insert into TEST_TEMP values ('789', to_date('1990-03-03', 'YYYY-MM-DD')); insert into TEST_TEMP values ('987', to_date('1999-04-03', 'YYYY-MM-DD')); CREATE VIEW TEST AS SELECT * FROM TEST_TEMP OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY; create or replace view TEMP_COUNT1 as SELECT tbl."NAME", 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 TEST tbl; SELECT COUNT(*) FROM TEMP_COUNT1 WHERE "IS_CONTROL_GROUP" = 0;