Project 2

Dear sir/madam,

I am excited to submit my second and final project for this module. This project was equally as if not more interesting and engaging as compared to project 1, requiring the student to effectively put into practice almost all of the skills learned over the course of the module. A few notes about my submission:

1. The project text specifically requested all solutions to be included in the SQL file, but the project also requires some pivot tables and representations in Python and Excel which can't be included in the SQL file. I have included all of my Python code but the Excel files are attached separately.
2. The aforementioned pivot tables are contained within the appropriately named .XLSX file corresponding to the requirement that concerns the pivot tables. Within the Excel sheet towards the complete right-hand side of each sheet after all of the data are the pivot tables.
3. I have added in comments across my .SQL script file explaining the reasons behind some of my code design choices for clarity sake. I hope these are informative and convey my intentions clearly.
4. I have also attached a backup of my entire schema for verification purposes, named "alumni_complete.sql". The main .SQL script file containing the code for this project is named "SL-p2-structures.sql".
5. Regarding the final project requirement, I have gotten slightly different percentages for each strata of alumni which I would assume can be attributed to me using all of the available data rather than the non-null records.

As always, I look forward to your feedback!

Best regards, and many thanks to the hardworking team of TSEs,

Rahul Singh