Talk:Big Hardware Donations
I can probably pull some stats from the database if given some criteria, like a minimum dollar amount to look for or a minimum number of lines in a receipt. RfS
- That would be helpful. I'd start with 2005 only. (I'm interested in the long haul as well, but it's less important.) Maybe try over $100, but increase that number if it pulls up too much. At this stage I'd like to see maybe 15 company names. I like your line number idea as well, so use whichever method you think it's better. Many thanks, --Pete 10:18, 3 Jan 2006 (PST)
some results
Here are some numbers. 11 donors > 500 in 2005. 14 above 400, etc. Past years included. Tell me what you want. RfS
fgdb=# SELECT EXTRACT( YEAR FROM created ), COUNT(*) FROM donation WHERE cashdonation + monitorfee >= 500 GROUP BY 1 ORDER BY 1;
date_part | count
+-------
2001 | 1 2002 | 1 2003 | 3 2004 | 19 2005 | 11
(5 rows)
fgdb=# SELECT EXTRACT( YEAR FROM created ), COUNT(*) FROM donation WHERE cashdonation + monitorfee >= 400 GROUP BY 1 ORDER BY 1;
date_part | count
+-------
2001 | 2 2002 | 2 2003 | 5 2004 | 24 2005 | 14
(5 rows)
fgdb=# SELECT EXTRACT( YEAR FROM created ), COUNT(*) FROM donation WHERE cashdonation + monitorfee >= 300 GROUP BY 1 ORDER BY 1;
date_part | count
+-------
2001 | 2 2002 | 4 2003 | 12 2004 | 33 2005 | 28
(5 rows)
fgdb=# SELECT EXTRACT( YEAR FROM created ), COUNT(*) FROM donation WHERE cashdonation + monitorfee >= 200 GROUP BY 1 ORDER BY 1;
date_part | count
+-------
2001 | 5 2002 | 11 2003 | 22 2004 | 63 2005 | 68
(5 rows)
fgdb=# SELECT EXTRACT( YEAR FROM created ), COUNT(*) FROM donation WHERE cashdonation + monitorfee >= 100 GROUP BY 1 ORDER BY 1;
date_part | count
+-------
2001 | 17 2002 | 51 2003 | 98 2004 | 193 2005 | 253
(5 rows)