SELECT CName FROM COURSE WHERE Credits  =  3 UNION SELECT CName FROM COURSE WHERE Credits  =  1 AND Hours  =  4
Find the names of courses that have either 3 credits or 1 credit but 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
Find the names of courses that have either 3 credits or 1 credit but 4 hours .