library(RODBC) pm <- odbcConnect("perlmonks") nodes.all <- list(Su00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 0 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), Su01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 0 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), Su02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 0 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), Su03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 0 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), Su04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 0 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o"), Mo00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 1 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), Mo01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 1 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), Mo02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 1 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), Mo03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 1 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), Mo04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 1 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o"), Tu00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 2 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), Tu01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 2 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), Tu02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 2 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), Tu03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 2 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), Tu04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 2 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o"), We00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 3 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), We01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 3 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), We02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 3 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), We03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 3 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), We04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 3 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o"), Th00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 4 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), Th01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 4 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), Th02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 4 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), Th03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 4 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), Th04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 4 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o"), Fr00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 5 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), Fr01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 5 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), Fr02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 5 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), Fr03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 5 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), Fr04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 5 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o"), Sa00=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 6 AND EXTRACT('year' FROM createtime) = 2000 GROUP BY createtime::date) AS o"), Sa01=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 6 AND EXTRACT('year' FROM createtime) = 2001 GROUP BY createtime::date) AS o"), Sa02=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 6 AND EXTRACT('year' FROM createtime) = 2002 GROUP BY createtime::date) AS o"), Sa03=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 6 AND EXTRACT('year' FROM createtime) = 2003 GROUP BY createtime::date) AS o"), Sa04=sqlQuery(pm,"SELECT count FROM (SELECT createtime::date, count(*) FROM node_times WHERE EXTRACT('dow' FROM createtime::date) = 6 AND EXTRACT('year' FROM createtime) = 2004 GROUP BY createtime::date) AS o")) boxplot(nodes_all)