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