CREATE TABLE table_train_244 ("id" NUMBER, "fasting_venous_plasma_glucose" NUMBER, "hemoglobin_a1c_hba1c" FLOAT, "diabetic" CLOB, "capillary_glycated_hemoglobin" FLOAT, "fasting_capillary_glucose" NUMBER, "borderline_fasting_capillary_glucose_level" NUMBER, "body_mass_index_bmi" FLOAT, "fasting_glucose" NUMBER, "NOUSE" FLOAT)

at least 1 of the following: a ) capillary glycated hemoglobin 5.7 _ 6.4 % , b ) fasting capillary glucose 100 _ 125 mg / dl, or c ) capillary glycated hemoglobin < 5.7 % and borderline fasting capillary glucose level 95 _ 99 mg / dl and a subsequent fasting venous plasma glucose 100 _ 125 mg / dl
SELECT * FROM table_train_244 WHERE (CASE WHEN capillary_glycated_hemoglobin >= 5.7 AND capillary_glycated_hemoglobin <= 6.4 THEN 1 ELSE 0 END + CASE WHEN fasting_capillary_glucose >= 100 AND fasting_capillary_glucose <= 125 THEN 1 ELSE 0 END + CASE WHEN capillary_glycated_hemoglobin < 5.7 AND borderline_fasting_capillary_glucose_level >= 95 AND borderline_fasting_capillary_glucose_level <= 99 AND fasting_venous_plasma_glucose >= 100 AND fasting_venous_plasma_glucose <= 125 THEN 1 ELSE 0 END) >= 1
SELECT * FROM "table_train_244" WHERE (CASE WHEN "capillary_glycated_hemoglobin" <= 6.4 AND "capillary_glycated_hemoglobin" >= 5.7 THEN 1 ELSE 0 END + CASE WHEN "fasting_capillary_glucose" <= 125 AND "fasting_capillary_glucose" >= 100 THEN 1 ELSE 0 END + CASE WHEN "borderline_fasting_capillary_glucose_level" <= 99 AND "borderline_fasting_capillary_glucose_level" >= 95 AND "capillary_glycated_hemoglobin" < 5.7 AND "fasting_venous_plasma_glucose" <= 125 AND "fasting_venous_plasma_glucose" >= 100 THEN 1 ELSE 0 END) >= 1