SELECT count(*) FROM pets WHERE weight  >  10
How many pets have a greater weight than 10?
SELECT count ( * ) FROM pets WHERE weight > 10
select count ( * ) from pets where weight > value
How many pets have a greater weight than 10 ?