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)