SELECT count(*) FROM pets WHERE weight  >  10
Find the number of pets whose weight is heavier than 10.
SELECT count ( * ) FROM pets WHERE weight > 10
select count ( * ) from pets where weight > value
Find the number of pets whose weight is heavier than 10 .