CREATE TABLE table_train_174 ("id" INT, "fasting_plasma_glucose_fpg" FLOAT, "hemoglobin_a1c_hba1c" FLOAT, "substance_dependence" BOOLEAN, "estimated_glomerular_filtration_rate_egfr" INT, "allergy_to_insulin_lispro" BOOLEAN, "urine_albumin_to_creatinine_ratio_uacr" INT, "smoking" BOOLEAN, "NOUSE" FLOAT)

has an estimated glomerular filtration rate rate < 75 ml / min / 1.73 m2 or has >= 75 ml / min / 1.73 m2 < estimated glomerular filtration rate < 90 ml / min / 1.73 m2 with a urine albumin to urine creatinine ratio > 30 mg / g.
SELECT * FROM table_train_174 WHERE estimated_glomerular_filtration_rate_egfr < 75 OR (estimated_glomerular_filtration_rate_egfr >= 75 AND estimated_glomerular_filtration_rate_egfr < 90 AND urine_albumin_to_creatinine_ratio_uacr > 30)
SELECT * FROM "table_train_174" WHERE ("estimated_glomerular_filtration_rate_egfr" < 75 OR "estimated_glomerular_filtration_rate_egfr" >= 75) AND ("estimated_glomerular_filtration_rate_egfr" < 75 OR "urine_albumin_to_creatinine_ratio_uacr" > 30) AND "estimated_glomerular_filtration_rate_egfr" < 90