SELECT count(*) FROM COURSE WHERE Credits  >  2
How many courses have more than 2 credits?
SELECT count ( * ) FROM COURSE WHERE Credits > 2
select count ( * ) from course where credits > value
How many courses have more than 2 credits ?