CREATE TABLE table_train_235 ("id" NUMBER, "urinary_protein" FLOAT, "nephrotic_range_proteinuria" BOOLEAN, "hepatic_disease" BOOLEAN, "estimated_glomerular_filtration_rate_egfr" NUMBER, "kidney_disease" BOOLEAN, "renal_transplantation" BOOLEAN, "NOUSE" FLOAT)

patients with chronic kidney disease stage with egfr < 30 ml / min
SELECT * FROM table_train_235 WHERE kidney_disease = 1 AND estimated_glomerular_filtration_rate_egfr < 30
SELECT * FROM "table_train_235" WHERE "estimated_glomerular_filtration_rate_egfr" < 30 AND "kidney_disease" = 1