create $1$ database that contains $5$ tables. These $5$ tables must contain at least $5$ columns. Each column must contain $5$ values. Your values must contain char, varchar, decimal, date, null, and primary key. Although the minimum is $5$ for each, I would recommend doing maybe $10$ so that it will be easier to do all of the data types and all of the queries.

After you create this database, you need to enter commands that will query the following information:

$1.$ Display one table. Then, display all tables.

$2.$ Functions to use correctly: in$,$ order by$,$ count, where, like, between, not, or$,$ and, group, having, update.

$3.$ Create at least one of these functions correctly: avg, max, or min.

$4.$ Display certain values in a specific column. Then display all values in a specific column.

$5.$ Create a NEW DATABASE. Add ONE EMPTY TABLE. Delete the empty table. Then drop the new database.

$6.$ Use the $\backslash$q command to exit mysql when you have completed all of the queries for this assignmentC