SQLize Online / PHPize Online  /  SQLtest Online

create table TEST_TEMP (NAME varchar(64), BIRTHDATE date); INSERT INTO TEMP_93983 (ID_CLIENT, FIRST_PRODUCT_START_DATE, LAST_PRODUCT_END_DATE, FIRST_CREDIT_START_DATE, LAST_CREDIT_END_DATE, FIRST_DEBIT_START_DATE, LAST_DEBIT_END_DATE, FIRST_SALARY_CARD_DATE, LAST_SALARY_CARD_END_DATE, FIRST_CRCARD_DATE, LAST_CRCARD_END_DATE, FIRST_DEBIT_C_DATE, LAST_DEBIT_C_END_DATE, MONTH_ON_BOOK, ACTIVE_PRODUCTS_NUM, ACTIVE_DEPOSITS_NUM, ACTIVE_MORTGAGE_NUM, CLOSED_MORTGAGE_NUM, ACTIVE_CREDITS_NUM, CLOSE_CREDITS_NUM, ACTIVE_CARDS_NUM, ACTIVE_CARDS_TRANS_3M, CLOSED_CARDS_NUM, TRANSACTIONS_ONBANK_6M_NUM, TRANSACTIONS_ONBANK_6M_AMT, SALARY_COUNT_3M, SALARY_COUNT_6M, DVS_ACCOUNTS_NUM, CURRENT_ACCOUNTS_NUM, SMS_DELIVERED_12M, OUTBOUND_CALLS_12M, TOTAL_CARD_ACC_BALANCE, TOTAL_DEPOSIT_ACC_BALANCE, TOTAL_CURRENT_ACC_BALANCE, TOTAL_LOAN_SUM, OVERDUE_LOAN_SUM, MONTHLY_PAYMENT, DTI, TOTAL_CARDS_TURNOVER_6M, AVG_SALARY_6M, AVG_SALARY_3M, LAST_APPLICATION_INCOME, IS_MIR_CARDHOLDER, IS_AEROFLOT_CARDHOLDER, IS_ONBANK_USER, IS_SMS_INFORM, IS_OTHER_PRODUCTS, IS_BORROWER, IS_SALARY_CLIENT_1, IS_DEBITOR, IS_APPL_3M, IS_APPL_WO_CL_REFUSE_6M, IS_APPL_REFUSED_12M, IS_ARREARS_0_3M, IS_CLOSED_CRED_ARRS_30M_PLUS, ACTIVE_CRED_ARREARS, ACTIVE_CREDITS_3M, LAST_CALLED_DATE, LAST_CONTACTED_DATE, LAST_SMS_SENT_DATE, LAST_SMS_DELIVER_DATE, LAST_CAMPAIGNID, CHANNEL_LAST, BALANCE, LAST_CREDIT_START_DATE, LAST_DEBIT_START_DATE, LAST_SALARY_CARD_DATE, LAST_CRCARD_DATE, LAST_DEBIT_C_DATE, FIRST_DBO_DATE, LAST_DBO_DATE, FIRST_SRENT_DATE, LAST_SRENT_DATE, ID_UC, ID_BANK_1, MODIFIED, ID_SOURCE, CODE_CLIENT, CLIENT_TYPE, SURNAME, NAME_1, PATRONYMIC, GENDER, BIRTHDATE, AGE, CITIZENSHIP, BANKNAME, ID_BANK_2, ID_BRANCH, ID_FILIAL, IS_OFFICE_WITHIN_CITY, REGION_FACT, CITY_FACT, REGION_REG, CITY_REG, POMK, PHONE, EMAIL, IS_VIP, IS_AFFILATED, IS_RESIDENT, IS_EMPLOYEE, IS_SALARY_CLIENT_2, SEGMENT_INCOME, SEGMENT_INC_CRITERIA, IS_BLACKLISTED, IS_NEGATIVE, IS_COMMUNICATION_REFUSED, IS_DEAD, PRODUCT_PENETRATION, SERVICE_PENETRATION, SALARY_ORG, SEGMENT_PRODUCT, SEGMENT_ACTIVITY, IS_EMPLOYEE_SMP, IS_EMPLOYEE_MOB, PRODUCT_PENETRATION_SMP, PRODUCT_PENETRATION_MOB, IS_SALARY_CLIENT_SMP, IS_SALARY_CLIENT_MOB, BRANCH_NAME, CITY_NAME, BRANCH_FORMAT, BRANCH_TYPE, BRANCH_STATUS, BRANCH_NAME_MSB, BRANCH_ADRESS, CODE, NAME_2) VALUES (14, TO_DATE('2008-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, TO_DATE('2012-01-01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, 146, 1, null, null, null, null, null, null, null, 0, null, null, 0, 0, null, null, null, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 'Нет', 'Нет', 'Бывший', 0, 0, 0, 0, 0, 0, 0, null, null, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, 0.0000, null, TO_DATE('2019-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null, 14, 3580, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), 1062, 'MIV_729864276', 'Ю', 'Петров', 'Никита', 'Васильевич', 'М', TO_DATE('2002-01-06', 'YYYY-MM-DD HH24:MI:SS'), 18, 'РФ', 'Банк ФББ', 2, 4, 10, 1, 'регион Нью-Йорк', 'Нью-Йорк', 'регион Новосибирск', 'Новосибирск', 2, '7-903-383-65-20', 'rtudo@lpuyml.ogfa', 0, 1, 0, 1, 0, 'Upper Mass', 'Остаток', 0, 0, 1, 0, 'Др. продукты', 'ДБО', 'ПАО "Рога и Копыта"', 'Потенциальный: on-bank; Счет; ОМС', 'Потенциальный', 0, 0, 'Срочный вклад Потреб. кредит', null, '1', '0', 'Отделение №4', 'Омск', 'Точка продаж', 'B', 'NULL', 'Отделение №4', 'адрес 4', 'КОД-1', 'Банк МОБ'); INSERT INTO TEMP_93983 (ID_CLIENT, FIRST_PRODUCT_START_DATE, LAST_PRODUCT_END_DATE, FIRST_CREDIT_START_DATE, LAST_CREDIT_END_DATE, FIRST_DEBIT_START_DATE, LAST_DEBIT_END_DATE, FIRST_SALARY_CARD_DATE, LAST_SALARY_CARD_END_DATE, FIRST_CRCARD_DATE, LAST_CRCARD_END_DATE, FIRST_DEBIT_C_DATE, LAST_DEBIT_C_END_DATE, MONTH_ON_BOOK, ACTIVE_PRODUCTS_NUM, ACTIVE_DEPOSITS_NUM, ACTIVE_MORTGAGE_NUM, CLOSED_MORTGAGE_NUM, ACTIVE_CREDITS_NUM, CLOSE_CREDITS_NUM, ACTIVE_CARDS_NUM, ACTIVE_CARDS_TRANS_3M, CLOSED_CARDS_NUM, TRANSACTIONS_ONBANK_6M_NUM, TRANSACTIONS_ONBANK_6M_AMT, SALARY_COUNT_3M, SALARY_COUNT_6M, DVS_ACCOUNTS_NUM, CURRENT_ACCOUNTS_NUM, SMS_DELIVERED_12M, OUTBOUND_CALLS_12M, TOTAL_CARD_ACC_BALANCE, TOTAL_DEPOSIT_ACC_BALANCE, TOTAL_CURRENT_ACC_BALANCE, TOTAL_LOAN_SUM, OVERDUE_LOAN_SUM, MONTHLY_PAYMENT, DTI, TOTAL_CARDS_TURNOVER_6M, AVG_SALARY_6M, AVG_SALARY_3M, LAST_APPLICATION_INCOME, IS_MIR_CARDHOLDER, IS_AEROFLOT_CARDHOLDER, IS_ONBANK_USER, IS_SMS_INFORM, IS_OTHER_PRODUCTS, IS_BORROWER, IS_SALARY_CLIENT_1, IS_DEBITOR, IS_APPL_3M, IS_APPL_WO_CL_REFUSE_6M, IS_APPL_REFUSED_12M, IS_ARREARS_0_3M, IS_CLOSED_CRED_ARRS_30M_PLUS, ACTIVE_CRED_ARREARS, ACTIVE_CREDITS_3M, LAST_CALLED_DATE, LAST_CONTACTED_DATE, LAST_SMS_SENT_DATE, LAST_SMS_DELIVER_DATE, LAST_CAMPAIGNID, CHANNEL_LAST, BALANCE, LAST_CREDIT_START_DATE, LAST_DEBIT_START_DATE, LAST_SALARY_CARD_DATE, LAST_CRCARD_DATE, LAST_DEBIT_C_DATE, FIRST_DBO_DATE, LAST_DBO_DATE, FIRST_SRENT_DATE, LAST_SRENT_DATE, ID_UC, ID_BANK_1, MODIFIED, ID_SOURCE, CODE_CLIENT, CLIENT_TYPE, SURNAME, NAME_1, PATRONYMIC, GENDER, BIRTHDATE, AGE, CITIZENSHIP, BANKNAME, ID_BANK_2, ID_BRANCH, ID_FILIAL, IS_OFFICE_WITHIN_CITY, REGION_FACT, CITY_FACT, REGION_REG, CITY_REG, POMK, PHONE, EMAIL, IS_VIP, IS_AFFILATED, IS_RESIDENT, IS_EMPLOYEE, IS_SALARY_CLIENT_2, SEGMENT_INCOME, SEGMENT_INC_CRITERIA, IS_BLACKLISTED, IS_NEGATIVE, IS_COMMUNICATION_REFUSED, IS_DEAD, PRODUCT_PENETRATION, SERVICE_PENETRATION, SALARY_ORG, SEGMENT_PRODUCT, SEGMENT_ACTIVITY, IS_EMPLOYEE_SMP, IS_EMPLOYEE_MOB, PRODUCT_PENETRATION_SMP, PRODUCT_PENETRATION_MOB, IS_SALARY_CLIENT_SMP, IS_SALARY_CLIENT_MOB, BRANCH_NAME, CITY_NAME, BRANCH_FORMAT, BRANCH_TYPE, BRANCH_STATUS, BRANCH_NAME_MSB, BRANCH_ADRESS, CODE, NAME_2) VALUES (14, TO_DATE('2008-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, TO_DATE('2012-01-01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, 146, 1, null, null, null, null, null, null, null, 0, null, null, 0, 0, null, null, null, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 'Нет', 'Нет', 'Бывший', 0, 0, 0, 0, 0, 0, 0, null, null, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, 0.0000, null, TO_DATE('2019-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null, 14, 3580, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), 1062, 'MIV_729864276', 'Ю', 'Петров', 'Никита', 'Васильевич', 'М', TO_DATE('2002-01-06', 'YYYY-MM-DD HH24:MI:SS'), 18, 'РФ', 'Банк ФББ', 2, 4, 10, 1, 'регион Нью-Йорк', 'Нью-Йорк', 'регион Новосибирск', 'Новосибирск', 2, '7-903-383-65-20', 'rtudo@lpuyml.ogfa', 0, 1, 0, 1, 0, 'Upper Mass', 'Остаток', 0, 0, 1, 0, 'Др. продукты', 'ДБО', 'ПАО "Рога и Копыта"', 'Потенциальный: on-bank; Счет; ОМС', 'Потенциальный', 0, 0, 'Срочный вклад Потреб. кредит', null, '1', '0', 'Отделение №4', 'Омск', 'Точка продаж', 'B', 'NULL', 'Отделение №4', 'адрес 4', 'КОД-1', 'Банк МОБ'); INSERT INTO TEMP_93983 (ID_CLIENT, FIRST_PRODUCT_START_DATE, LAST_PRODUCT_END_DATE, FIRST_CREDIT_START_DATE, LAST_CREDIT_END_DATE, FIRST_DEBIT_START_DATE, LAST_DEBIT_END_DATE, FIRST_SALARY_CARD_DATE, LAST_SALARY_CARD_END_DATE, FIRST_CRCARD_DATE, LAST_CRCARD_END_DATE, FIRST_DEBIT_C_DATE, LAST_DEBIT_C_END_DATE, MONTH_ON_BOOK, ACTIVE_PRODUCTS_NUM, ACTIVE_DEPOSITS_NUM, ACTIVE_MORTGAGE_NUM, CLOSED_MORTGAGE_NUM, ACTIVE_CREDITS_NUM, CLOSE_CREDITS_NUM, ACTIVE_CARDS_NUM, ACTIVE_CARDS_TRANS_3M, CLOSED_CARDS_NUM, TRANSACTIONS_ONBANK_6M_NUM, TRANSACTIONS_ONBANK_6M_AMT, SALARY_COUNT_3M, SALARY_COUNT_6M, DVS_ACCOUNTS_NUM, CURRENT_ACCOUNTS_NUM, SMS_DELIVERED_12M, OUTBOUND_CALLS_12M, TOTAL_CARD_ACC_BALANCE, TOTAL_DEPOSIT_ACC_BALANCE, TOTAL_CURRENT_ACC_BALANCE, TOTAL_LOAN_SUM, OVERDUE_LOAN_SUM, MONTHLY_PAYMENT, DTI, TOTAL_CARDS_TURNOVER_6M, AVG_SALARY_6M, AVG_SALARY_3M, LAST_APPLICATION_INCOME, IS_MIR_CARDHOLDER, IS_AEROFLOT_CARDHOLDER, IS_ONBANK_USER, IS_SMS_INFORM, IS_OTHER_PRODUCTS, IS_BORROWER, IS_SALARY_CLIENT_1, IS_DEBITOR, IS_APPL_3M, IS_APPL_WO_CL_REFUSE_6M, IS_APPL_REFUSED_12M, IS_ARREARS_0_3M, IS_CLOSED_CRED_ARRS_30M_PLUS, ACTIVE_CRED_ARREARS, ACTIVE_CREDITS_3M, LAST_CALLED_DATE, LAST_CONTACTED_DATE, LAST_SMS_SENT_DATE, LAST_SMS_DELIVER_DATE, LAST_CAMPAIGNID, CHANNEL_LAST, BALANCE, LAST_CREDIT_START_DATE, LAST_DEBIT_START_DATE, LAST_SALARY_CARD_DATE, LAST_CRCARD_DATE, LAST_DEBIT_C_DATE, FIRST_DBO_DATE, LAST_DBO_DATE, FIRST_SRENT_DATE, LAST_SRENT_DATE, ID_UC, ID_BANK_1, MODIFIED, ID_SOURCE, CODE_CLIENT, CLIENT_TYPE, SURNAME, NAME_1, PATRONYMIC, GENDER, BIRTHDATE, AGE, CITIZENSHIP, BANKNAME, ID_BANK_2, ID_BRANCH, ID_FILIAL, IS_OFFICE_WITHIN_CITY, REGION_FACT, CITY_FACT, REGION_REG, CITY_REG, POMK, PHONE, EMAIL, IS_VIP, IS_AFFILATED, IS_RESIDENT, IS_EMPLOYEE, IS_SALARY_CLIENT_2, SEGMENT_INCOME, SEGMENT_INC_CRITERIA, IS_BLACKLISTED, IS_NEGATIVE, IS_COMMUNICATION_REFUSED, IS_DEAD, PRODUCT_PENETRATION, SERVICE_PENETRATION, SALARY_ORG, SEGMENT_PRODUCT, SEGMENT_ACTIVITY, IS_EMPLOYEE_SMP, IS_EMPLOYEE_MOB, PRODUCT_PENETRATION_SMP, PRODUCT_PENETRATION_MOB, IS_SALARY_CLIENT_SMP, IS_SALARY_CLIENT_MOB, BRANCH_NAME, CITY_NAME, BRANCH_FORMAT, BRANCH_TYPE, BRANCH_STATUS, BRANCH_NAME_MSB, BRANCH_ADRESS, CODE, NAME_2) VALUES (14, TO_DATE('2008-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, TO_DATE('2012-01-01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, 146, 1, null, null, null, null, null, null, null, 0, null, null, 0, 0, null, null, null, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 'Нет', 'Нет', 'Бывший', 0, 0, 0, 0, 0, 0, 0, null, null, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, 0.0000, null, TO_DATE('2019-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null, 14, 3580, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), 1062, 'MIV_729864276', 'Ю', 'Петров', 'Никита', 'Васильевич', 'М', TO_DATE('2002-01-06', 'YYYY-MM-DD HH24:MI:SS'), 18, 'РФ', 'Банк ФББ', 2, 4, 10, 1, 'регион Нью-Йорк', 'Нью-Йорк', 'регион Новосибирск', 'Новосибирск', 2, '7-903-383-65-20', 'rtudo@lpuyml.ogfa', 0, 1, 0, 1, 0, 'Upper Mass', 'Остаток', 0, 0, 1, 0, 'Др. продукты', 'ДБО', 'ПАО "Рога и Копыта"', 'Потенциальный: on-bank; Счет; ОМС', 'Потенциальный', 0, 0, 'Срочный вклад Потреб. кредит', null, '1', '0', 'Отделение №4', 'Омск', 'Точка продаж', 'B', 'NULL', 'Отделение №4', 'адрес 4', 'КОД-1', 'Банк МОБ'); INSERT INTO TEMP_93983 (ID_CLIENT, FIRST_PRODUCT_START_DATE, LAST_PRODUCT_END_DATE, FIRST_CREDIT_START_DATE, LAST_CREDIT_END_DATE, FIRST_DEBIT_START_DATE, LAST_DEBIT_END_DATE, FIRST_SALARY_CARD_DATE, LAST_SALARY_CARD_END_DATE, FIRST_CRCARD_DATE, LAST_CRCARD_END_DATE, FIRST_DEBIT_C_DATE, LAST_DEBIT_C_END_DATE, MONTH_ON_BOOK, ACTIVE_PRODUCTS_NUM, ACTIVE_DEPOSITS_NUM, ACTIVE_MORTGAGE_NUM, CLOSED_MORTGAGE_NUM, ACTIVE_CREDITS_NUM, CLOSE_CREDITS_NUM, ACTIVE_CARDS_NUM, ACTIVE_CARDS_TRANS_3M, CLOSED_CARDS_NUM, TRANSACTIONS_ONBANK_6M_NUM, TRANSACTIONS_ONBANK_6M_AMT, SALARY_COUNT_3M, SALARY_COUNT_6M, DVS_ACCOUNTS_NUM, CURRENT_ACCOUNTS_NUM, SMS_DELIVERED_12M, OUTBOUND_CALLS_12M, TOTAL_CARD_ACC_BALANCE, TOTAL_DEPOSIT_ACC_BALANCE, TOTAL_CURRENT_ACC_BALANCE, TOTAL_LOAN_SUM, OVERDUE_LOAN_SUM, MONTHLY_PAYMENT, DTI, TOTAL_CARDS_TURNOVER_6M, AVG_SALARY_6M, AVG_SALARY_3M, LAST_APPLICATION_INCOME, IS_MIR_CARDHOLDER, IS_AEROFLOT_CARDHOLDER, IS_ONBANK_USER, IS_SMS_INFORM, IS_OTHER_PRODUCTS, IS_BORROWER, IS_SALARY_CLIENT_1, IS_DEBITOR, IS_APPL_3M, IS_APPL_WO_CL_REFUSE_6M, IS_APPL_REFUSED_12M, IS_ARREARS_0_3M, IS_CLOSED_CRED_ARRS_30M_PLUS, ACTIVE_CRED_ARREARS, ACTIVE_CREDITS_3M, LAST_CALLED_DATE, LAST_CONTACTED_DATE, LAST_SMS_SENT_DATE, LAST_SMS_DELIVER_DATE, LAST_CAMPAIGNID, CHANNEL_LAST, BALANCE, LAST_CREDIT_START_DATE, LAST_DEBIT_START_DATE, LAST_SALARY_CARD_DATE, LAST_CRCARD_DATE, LAST_DEBIT_C_DATE, FIRST_DBO_DATE, LAST_DBO_DATE, FIRST_SRENT_DATE, LAST_SRENT_DATE, ID_UC, ID_BANK_1, MODIFIED, ID_SOURCE, CODE_CLIENT, CLIENT_TYPE, SURNAME, NAME_1, PATRONYMIC, GENDER, BIRTHDATE, AGE, CITIZENSHIP, BANKNAME, ID_BANK_2, ID_BRANCH, ID_FILIAL, IS_OFFICE_WITHIN_CITY, REGION_FACT, CITY_FACT, REGION_REG, CITY_REG, POMK, PHONE, EMAIL, IS_VIP, IS_AFFILATED, IS_RESIDENT, IS_EMPLOYEE, IS_SALARY_CLIENT_2, SEGMENT_INCOME, SEGMENT_INC_CRITERIA, IS_BLACKLISTED, IS_NEGATIVE, IS_COMMUNICATION_REFUSED, IS_DEAD, PRODUCT_PENETRATION, SERVICE_PENETRATION, SALARY_ORG, SEGMENT_PRODUCT, SEGMENT_ACTIVITY, IS_EMPLOYEE_SMP, IS_EMPLOYEE_MOB, PRODUCT_PENETRATION_SMP, PRODUCT_PENETRATION_MOB, IS_SALARY_CLIENT_SMP, IS_SALARY_CLIENT_MOB, BRANCH_NAME, CITY_NAME, BRANCH_FORMAT, BRANCH_TYPE, BRANCH_STATUS, BRANCH_NAME_MSB, BRANCH_ADRESS, CODE, NAME_2) VALUES (373, TO_DATE('2006-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, TO_DATE('2013-01-01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2018-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, 41, null, null, null, null, null, null, null, null, null, null, null, 0, 0, null, null, null, null, null, null, 0.0000, null, null, null, null, null, null, null, null, 0, 1, 0, 0, 0, 'Нет', 'Нет', 'Текущий', 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, 0.0000, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null, 373, -1, TO_DATE('2020-01-01', 'YYYY-MM-DD HH24:MI:SS'), 1041, 'MIV_69142287', 'Ф', 'Иванов', 'Артем', 'Васильевич', 'М', TO_DATE('2002-05-04', 'YYYY-MM-DD HH24:MI:SS'), 18, 'РФ', 'Банк СМП', 0, 3, 4, 1, 'регион Санкт-Петербург', 'Санкт-Петербург', 'регион Нью-Йорк', 'Нью-Йорк', 2, '+7-991-501-76-64', 'efumg@erty.arw', 0, 0, 0, 0, 0, 'Affluent', 'Остаток', 0, 0, 1, 0, null, null, null, null, 'Активный', 0, 0, 'Срочный вклад Потреб. кредит', null, '1', '1', 'Отделение №3', 'Санкт-Петербург', 'Точка продаж', 'NULL', 'NULL', 'Отделение №3', 'адрес 3', 'КОД-0', 'Банк СМП'); CREATE VIEW TEST AS SELECT * FROM TEST_TEMP OFFSET 0 ROWS FETCH NEXT 100 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;