Answer to Question #1883 in Databases | SQL | Oracle | MS Access for Stefan

Question

For each student count the number of courses he or she has taken: Got this one it is SELECT Name, COUNT(CourseNumber) AS Course_Count FROM STUDENTS LEFT JOIN COURSES ON STUDENTS.STudentID=COURSES.Student ID GROUP BY Name;
Having problems with: Modify the above query to only count CMIS Courses (a coursenumber is ex. CMIS345) Hint: You'll need to use the SUBSTR function on the COURSENUMBER column to extract the first four letters. then compare this to 'CMIS'

Answer 1

Unfortunately, your question requires more work than to be done for free. You can submit it as an assignment to our control panel set the deadline and our experts will assist you.