Many model biological organism database projects created a standard, shared schema for storing their projects' information, and it is called Chado.

Many model biological organism database projects created a standard, shared schema for storing their projects' information, and it is called Chado. The complete schema is outside of the scope of this class, but for this problem you'll need to use two tables from it:

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 textbased names in this table. The cvterm_id field of this table can be directly linked to the type_id of the feature table.

Login to MySQL using your user name and connect to the "Data_Here" database. Write a 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 these):

+--------------+---------------+

| feature type | feature count |

+--------------+---------------+

| assembly    |            1 |

| exon        |         4200 |

| gene        |         4200 |

| mRNA        |         4200 |

| polypeptide |         4200 |

+--------------+---------------+