[NCUC E-team] Question

[Tapani Tarvainen]

On Nov 06 15:54, William Drake (wjdrake at gmail.com) wrote:

> it would be good to at least have an updated status
> report on the size and composition of perennially out of touch
> contingent so we know what what we’re dealing and can ponder.

Once we have last verification dates in the database it should
be easy enough to generate such reports automatically
(a simple SQL query).

E.g., member counts by year when they were last confirmed or
something like that... e.g.,

ncuc=> select count(*),extract (year from date) as y from ncucer_verified group by y;
 count |  y
-------+------
   208 | 2013
    89 | 2014
(2 rows)

Or monthly or whatever.

-- 
Tapani Tarvainen