Advanced courses by ID number — DBMS OPPE Question
Advanced courses by ID number
00:00
In the course table, each course_id is a two-letter department prefix followed by a four-digit number (for example CS2001). List the courses whose numeric portion is 2000 or greater, extracting the digits from the course_id (everything from the third character onward) and comparing them as a number. Return the columns course_id and title, sorted by course_id (ascending).
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan