CREATE TABLE vocals (TYPE VARCHAR2)

Which vocal type is the most frequently appearring type?
SELECT TYPE FROM vocals GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1
SELECT "TYPE" FROM "vocals" GROUP BY "TYPE" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY