Update my script to have these qualifications:

Submit the script that does the following:

Deletes schema if it exists

Creates schema if it does not exist

Includes use command

Creates tables with relationships.

One table must have a date field.

One table must have a set or enum field.

The date field and the set$/$enum fields must be populated in all rows of the table.

Inserts at least $5$ records in each table

Create a query using the date field. Possibilities include that a field equals a certain date, or is between $2$ dates. You could pick the earliest or latest date. The query needs to filter based on the date field.

Create a query that performs any calculation. Examples include adding, subtracting, multiplying or dividing.

Create a query that performs an average or minimum or maximum.

Create a query that joins two or more tables and pull fields from each table.

Create a query that uses GROUP BY and HAVING.

Create a query that concatenates at least $2$ fields with a space in between. Example: first name and last name.