Task: Text to Code
Input (English): Step 1: find the semester_name of Semesters table for which semester_name equals Master.
Step 2: find the semester_name of Semesters table for which semester_description equals Bachelor.
Step 3: show the rows that are in both the results of step 1 and the results of step 2
Output (English): SELECT semester_name FROM Semesters WHERE semester_name = "Master" INTERSECT SELECT semester_name FROM Semesters WHERE semester_description = "Bachelor"