Jack A Ross jackross
jackross
/ march_2011_2015_payment_month.txt
Created
September 19, 2014 16:47
March 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Mar 2011 | |
| Sourcing data from facts.memberships for Mar 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Mar 2010 94872 2730284 28.78 2638824 91460 0.03350 | |
| Mar 2011 76999 2428158 31.53 2368200 59938 0.02468 |
jackross
/ may_2011_2015_payment_month.txt
Created
September 19, 2014 16:48
May 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for May 2011 | |
| Sourcing data from facts.memberships for May 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| May 2010 24762 766049 30.94 734853 31196 0.04072 | |
| May 2011 29020 910980 31.39 860595 50385 0.05531 |
jackross
/ june_2011_2015_payment_month.txt
Created
September 19, 2014 16:49
June 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Jun 2011 | |
| Sourcing data from facts.memberships for Jun 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Jun 2010 36534 1149691 31.47 1096726 52965 0.04607 | |
| Jun 2011 34697 1064319 30.67 1019424 44885 0.04217 |
jackross
/ july_2011_2015_payment_month.txt
Created
September 19, 2014 16:49
July 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Jul 2011 | |
| Sourcing data from facts.memberships for Jul 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Jul 2010 22185 773460 34.86 734053 39407 0.05095 | |
| Jul 2011 20281 699990 34.51 664949 35041 0.05006 |
jackross
/ august_2011_2015_payment_month.txt
Created
September 19, 2014 16:50
August 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Aug 2011 | |
| Sourcing data from facts.memberships for Aug 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Aug 2010 22023 786798 35.73 657753 129045 0.16401 | |
| Aug 2011 21692 709476 32.71 623986 85490 0.12050 |
jackross
/ september_2011_2015_payment_month.txt
Created
September 19, 2014 16:50
September 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Sep 2011 | |
| Sourcing data from facts.memberships for Sep 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Sep 2010 21981 822654 37.43 491615 331039 0.40240 | |
| Sep 2011 24989 938509 37.56 538024 400485 0.42672 |
jackross
/ october_2011_2015_payment_month.txt
Created
September 19, 2014 16:51
October 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Oct 2011 | |
| Sourcing data from facts.memberships for Oct 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Oct 2010 34017 1313515 38.61 425800 887715 0.67583 | |
| Oct 2011 35298 1278274 36.21 441042 837232 0.65497 |
jackross
/ november_2011_2015_payment_month.txt
Created
September 19, 2014 16:52
November 2011 - 2015 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Nov 2011 | |
| Sourcing data from facts.memberships for Nov 2010 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Nov 2010 32171 1186334 36.88 290652 895682 0.75500 | |
| Nov 2011 28318 1054941 37.25 231613 823328 0.78045 |
jackross
/ december_2010_2014_payment_month.txt
Created
September 19, 2014 16:53
December 2010 - 2014 Payment Month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | |
| ---------------------------------------------------------------- | |
| Sourcing data from facts.memberships for Dec 2010 | |
| Sourcing data from facts.memberships for Dec 2009 | |
| Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $ | |
| ------------- ------- ---------- ---------- ---------- ---------- -------- | |
| Dec 2009 77993 2229775 28.59 2162510 67255 0.03016 | |
| Dec 2010 81479 2284552 28.04 2206707 77845 0.03407 |
jackross
/ gist:54a9ab5e94ec2a7c69ed
Last active
August 29, 2015 14:10
— forked from joevandyk/gist:4531663
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| begin; | |
| /* | |
| Problem: I don't want the application to really care about how the data is | |
| structured in the database. The application / view code needs to work | |
| with the data in a sane format, without worrying about normalization, joins, | |
| eager fetching, etc. | |
| DB Schema Overview: | |
| orders |