SQL table for the list below, i got the data i just want help on the table approach thank you

Your first task is to create new database tables deployment script for your report data. You will work with these tables for the rest of the challenge. It is up to you how to structure/name/index/test/document the tables, and how many tables to make.

We want you to create tables that can provide pre-computed data and answer for the following questions:

- For all data, What are the names of the characters? How many characters are there?

- For each season, which character has the most lines?

- For each season, what is the number of times a "That's what she said" joke comes up?

- For each season, what is the average percent of lines each character contributed per episode?

- For each character, what is the average number of words per line?

- For each character, what is the most common word?

- For each character, what is the number of episodes where the character does not have a line?