67 232
Assignments Done
99,2%
Successfully Done
In November 2018

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

Question #1883
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'
Expert's answer
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.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions