Difference between revisions of "Talk:Collins Foundation Final Report"
| Line 16: | Line 16: | ||
ORDER BY 1; | ORDER BY 1; | ||
| − | + | ==Total hours by year:== | |
| + | fgdb=# SELECT EXTRACT( YEAR FROM created), SUM( hours ) FROM memberhour | ||
| + | WHERE jobtype NOT IN ('Adoption') GROUP BY 1 ORDER BY 1; | ||
| − | ''should I include any recycling data? Is it really pertinent at all?'' | + | |
| + | ''should I include any recycling data? Is it really pertinent at all? how abotu "no info for 2006"'' | ||
: Note: Teaching might be people teaching adoption classes. [[User:Rfs|RfS]] 18:23, 24 January 2007 (PST) | : Note: Teaching might be people teaching adoption classes. [[User:Rfs|RfS]] 18:23, 24 January 2007 (PST) | ||
Revision as of 18:36, 25 January 2007
this is the formula used for generating numbers relating to volunteers & their hours
"Build" volunteer count by year:
fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid ) FROM memberhour WHERE jobtype IN ('AdvancedTesting', 'Build', 'Enterprise', 'Evaluation', 'Laptops', 'Quality', 'Repair', 'Sorting', 'Teaching') GROUP BY 1 ORDER BY 1;
"Adoption" volunteer count by year:
fgdb=# SELECT EXTRACT( YEAR FROM created), COUNT( DISTINCT memberid ) FROM memberhour WHERE jobtype IN ('DataEntry', 'FrontDesk', 'Misc', 'Printers', 'Receiving', 'Recycling', 'Testing', 'Adoption') GROUP BY 1 ORDER BY 1;
Total hours by year:
fgdb=# SELECT EXTRACT( YEAR FROM created), SUM( hours ) FROM memberhour WHERE jobtype NOT IN ('Adoption') GROUP BY 1 ORDER BY 1;
should I include any recycling data? Is it really pertinent at all? how abotu "no info for 2006"
- Note: Teaching might be people teaching adoption classes. RfS 18:23, 24 January 2007 (PST)