Task: Text to Code
Input (English): Find the names of courses that have either 3 credits or 1 credit but 4 hours.
Output (English): SELECT CName FROM COURSE WHERE Credits  =  3 UNION SELECT CName FROM COURSE WHERE Credits  =  1 AND Hours  =  4