Given the following table, COURSES, with the following rows, what values are generated by the query below ? SELECT DISTINCT SUBSTRING(course_code, 1, 4) FROM courses WHERE SUBSTRING(course_code, 1, 1) = 'C'
Given the following table, COURSES, with the following rows, what values are generated by the query below ?
SELECT DISTINCT SUBSTRING(course_code, 1, 4)
FROM courses
WHERE SUBSTRING(course_code, 1, 1) = 'C'
COURSE_CODE COURSE_NAME
COMP1027 Introduction to
COMP2007 Database Systems
CCSD1001 Linux
CCSD5002 Java
OSSS8027 Cloud Computing
ENGL5001 Technical Writing
SELECT DISTINCT SUBSTRING(course_code, 1, 4)
FROM courses
WHERE SUBSTRING(course_code, 1, 1) = 'C'
CCSD, ENGL
CCSD, OSSS
COMP, CCSD
COMP, ENGL
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)