Solutions for Claire's SQL Puzzlers

These are solutions to Claire Carrol's Advanced SQL challenges. The solutions are written in BigQuery SQL.

For fun, these solutions have been compiled as a dbt project.

Completed Puzzles:

• Subscription Price Changes (instructions): Found in /models/subscription_price_changes
• Apportioning Payments (instructions): Found in /models/apportioning_payments

Installation Instructions

Requires Python 3.6 >= 3.8

1. virtualenv -p <path to Python> venv
2. source venv/bin/activate
3. pip install -r requirements.txt
4. dbt deps

You'll need to setup a profile in your ~/.dbt/profiles.yml (docs), and when that's done you can test your installation using dbt debug.