Data downloaded from https://rebrickable.com/downloads/

We explore complex problems using JOINS, CTEs, and WINDOW functions.

Note: parts.csv was imported using SSIS due to an error importing as a regular flat file in SQL server management studio.

Process: Data Flow Task > Flat file source > OLE DB destination > Execute task