SELECT full_name, count(DISTINCT a.lake_id) as sp_count FROM lakes a, species b, lakes_species c WHERE full_name like 'Daphnia%' AND a.lake_id=c.lake_id AND b.species_id=c.species_id GROUP BY full_name;