Create a table that groups usernames based on their first character into two categories: vowels and consonants. The resulting table should have a 'type' column with possible values of 'vowels' or 'consonants', and a 'count' column indicating the count of usernames in each category. The first row of the table should correspond to the 'consonants' category, displaying its count. eg: Type. $|$Count consonants $|19$ vowels $|21$

Tables Schema as Below:

users

columnName dataType

id int

username varchar

email varchar

remember$\_$token varchar

created$\_$at datetime

updated$\_$at datetime

password$\_$digest varchar