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