1. Final Grade Calculation Query:

• Write and run an SQL query to calculate your current final grade out of 100, excluding incomplete deliverables.
• The query should display the count, average score of each deliverable type, and your overall final grade.
• Submit the SQL code and screenshots of the query results.

2. Minimum Grade Analysis:

• Input data for all course deliverables, using '0' for grades not yet received.
• Run a query to determine the minimum possible final grade you can achieve.
• Submit the SQL code and a screenshot of the result.

3. Maximum Grade Analysis:

• Fill in all deliverable data, inputting the maximum possible scores for grades not yet received.
• Run a query to calculate the maximum possible final grade.
• Submit the SQL code and a screenshot of the result.

4. Bonus - Letter Grade Table:

• Create a new table in your database for letter grades as per the course syllabus.
• Include a screenshot of this table.

5. Bonus - Letter Grade Calculation Queries:

• Develop and run queries to calculate your letter grade for both the minimum and maximum grades.
• Submit the SQL codes and screenshots of the outcomes.

6. Macro Development:

Develop a macro for the database.

Include a screenshot of the macro designer and its outcome.

Explain the purpose and function of this macro.

Develop an embedded macro within the database.

Include a screenshot of the macro design and its outcome.

Provide an explanation of the macro's purpose and functionality.

Please ensure that all submissions are clear, complete, and in the required format.