CREATE TABLE table_test_26 ("id" NUMBER, "bleeding" NUMBER, "left_ventricular_ejection_fraction_lvef" NUMBER, "left_main_coronary_artery_disease" BOOLEAN, "uncontrolled_diabetes" BOOLEAN, "hiv_infection" BOOLEAN, "hemoglobin_a1c_hba1c" FLOAT, "hepatitis_b_infection" BOOLEAN, "renal_disease" BOOLEAN, "unprotected_left_main_disease" BOOLEAN, "creatinine_clearance_cl" FLOAT, "stenosis" NUMBER, "hepatitis_c_infection" BOOLEAN, "alcohol_abuse" BOOLEAN, "body_mass_index_bmi" FLOAT, "NOUSE" FLOAT)

left main coronary artery disease with 50 % stenosis
SELECT * FROM table_test_26 WHERE left_main_coronary_artery_disease = 1 AND stenosis = 50
SELECT * FROM "table_test_26" WHERE "left_main_coronary_artery_disease" = 1 AND "stenosis" = 50