CREATE TABLE table_train_120 ("id" NUMBER, "residual_neurologic_impairment" BOOLEAN, "mini_mental_state_examination_mmse" NUMBER, "systolic_blood_pressure_sbp" NUMBER, "memory_impairments" BOOLEAN, "progressive_neurologic_disease" BOOLEAN, "epilepsy" BOOLEAN, "head_injury" BOOLEAN, "stroke" BOOLEAN, "multiple_sclerosis" BOOLEAN, "dementia" BOOLEAN, "diastolic_blood_pressure_dbp" NUMBER, "heart_rate" NUMBER, "intracranial_brain_lesions" BOOLEAN, "neurological_disease" BOOLEAN, "ad" BOOLEAN, "neurosurgery" BOOLEAN, "hypertension" BOOLEAN, "clinical_dementia_rating_cdr" FLOAT, "NOUSE" FLOAT)

clinical diagnosis of mild ad defined by: clinical dementia rating ( cdr ) = 0.5 _ 1, mini mental state examination ( mmse ) > / = 20 , demonstration or history of memory impairments
SELECT * FROM table_train_120 WHERE ad = 1 OR (clinical_dementia_rating_cdr >= 0.5 AND clinical_dementia_rating_cdr <= 1 AND mini_mental_state_examination_mmse >= 20 AND memory_impairments = 1)
SELECT * FROM "table_train_120" WHERE ("ad" = 1 OR "clinical_dementia_rating_cdr" <= 1) AND ("ad" = 1 OR "clinical_dementia_rating_cdr" >= 0.5) AND ("ad" = 1 OR "memory_impairments" = 1) AND ("ad" = 1 OR "mini_mental_state_examination_mmse" >= 20)