SELECT full_name, count(full_name) 
FROM species,lakes_species,lakes 
WHERE species.species_id=lakes_species.species_id AND lakes.lake_id=lakes_species.lake_id AND province='QUEBEC' 
GROUP BY full_name;