-- Database schema
| course : course_id [ INTEGER ] primary_key , courseLevel [ TEXT ] | person : p_id [ INTEGER ] primary_key , professor [ INTEGER ] , student [ INTEGER ] , hasPosition [ TEXT ] , inPhase [ TEXT ] , yearsInProgram [ TEXT ] | advisedBy : p_id [ INTEGER ] advisedBy.p_id = person.p_id , p_id_dummy [ INTEGER ] advisedBy.p_id_dummy = person.p_id | taughtBy : course_id [ INTEGER ] taughtBy.course_id = course.course_id , p_id [ INTEGER ] taughtBy.p_id = person.p_id |
-- -- How many courses are there for basic or medium undergraduate courses?

SELECT COUNT(course_id) FROM course WHERE courseLevel = 'Level_300';