SELECT CName FROM COURSE WHERE Credits  =  1
What are the names of courses with 1 credit?
SELECT CName FROM COURSE WHERE Credits = 1
select cname from course where credits = value
What are the names of courses with 1 credit ?