Using your populated star schema, create DML select statements for the following requirements. If you can't answer all five questions with your existing schema, you may need to alter your schema and then repopulate it with new values.

• Return the total bid dollar amount by customer zip code.
• Return the avg bid dollar amount by customer state.
• Return the total bid dollar amount by month.
• Return the total bid dollar amount by customer zip code having a total bid dollar amount greater than $100.

Once you have completed all your DML (select commands) copy and paste the script into a Word document and submit it.