Hello,

I am completing a mysql question using these parameters:

feature: This is a 'normalized' schema, and all biological feature types are stored in this same table. The type_id column distinguishes them by giving each a different numerical type.

cvterm: Each of the numerical types from the feature table are given more user-friendly text-based names in this table. The cvterm_id field of this table can be directly linked to the type_id of the feature table.

Write an SQL query which lists the types of features in the feature table along with a count of each. Your output should look like this (using column aliases to match mine):

I would like some help troubleshooting my command. I keep recieving a NULL table, which I have also attached.

My current command is below:

Select feature.name as "feature type" , count(cvterm.cvterm_id) as "feature count" from feature inner join cvterm on feature.type_id = cvterm.cvterm_id group by feature.name;