CREATE VIEW count__subspecies_per_genus AS
SELECT 
genus, 
species, 
COUNT(*) subspecies_count 
FROM tax__subspecies
WHERE `subspecies`!=''
GROUP BY genus, species HAVING subspecies_count > 1;
/* Über HAVING werden die Species ohne Subspecies herausgefiltert. */