SELECT count(*) FROM COURSE WHERE Credits  >  2
Count the number of courses with more than 2 credits.
SELECT count ( * ) FROM COURSE WHERE Credits > 2
select count ( * ) from course where credits > value
Count the number of courses with more than 2 credits .