The third challenge in the Summer of SQL is taken from the Preppin’ Data project (2023 weeks 1-4).

This one makes sense to live on GitHub as well, so here are my solutions. I added them as four separate links since they are independent of each other.

Preppin’ Data 2023 week 1 – bank data, transactions

Preppin’ Data 2023 week 2 – bank data, creating IBANs

Preppin’ Data 2023 week 3 – sales transactions, joining with targets

Preppin’ Data 2023 week 4 – customer demographics, unions and pivots

I created a database and added the tables for the analysis using Microsoft SQL Server.

Details on the Summer of SQL challenge can be found here: https://github.com/wjsutton/the_summer_of_sql