SELECT CName FROM COURSE WHERE Credits  =  3 UNION SELECT CName FROM COURSE WHERE Credits  =  1 AND Hours  =  4
What are the names of courses that give either 3 credits, or 1 credit and 4 hours?
SELECT CName FROM COURSE WHERE Credits = 3 UNION SELECT CName FROM COURSE WHERE Credits = 1 AND Hours = 4
select cname from course where credits = value union select cname from course where credits = value and hours = value
What are the names of courses that give either 3 credits , or 1 credit and 4 hours ?