SQL execution pack
Load the seed data, run 00_create_comm437_execution_schema.sql, then run each query. The outputs must agree with the result files.
Coursework data. The tables are small, so the results show SQL skill, not business results.
Write-ups
Queries
- 00_create_comm437_execution_schema.sql
- 01_above_avg_performers.sql
- 01_album_value_classifier.sql
- 01_music_genre_revenue.sql
- 02_magazine_active_subscribers_by_category.sql
- 02_magazine_overlapping_subscriptions.sql
- 03_donor_1992_stewardship_extremes.sql
- 03_donor_1994_state_performance.sql
- 03_donor_activity_report.sql
- 03_donor_lapsed_reactivation.sql
- 03_donor_major_donor_identification.sql
- 03_donor_years_exceeding_target.sql
Query outputs
- 01_above_avg_performers.csv
- 01_album_value_classifier.csv
- 01_music_genre_revenue.csv
- 02_magazine_active_subscribers_by_category.csv
- 02_magazine_overlapping_subscriptions.csv
- 03_donor_1992_stewardship_extremes.csv
- 03_donor_1994_state_performance.csv
- 03_donor_activity_report.csv
- 03_donor_lapsed_reactivation.csv
- 03_donor_major_donor_identification.csv
- 03_donor_years_exceeding_target.csv