SELECT sampleid, animal, count(*) FROM sightings GROUP BY sampleid, animal