Changes between Version 7 and Version 8 of AdminTips

Timestamp:

2012-04-02T21:55:48Z (12 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -35 +35 @@
 
 Replace EVENT_ID to event id and COURSE_ID to course id.
+
+
+== Statistics ==
+New course
+{{{
+#!sql
+select * from courses where created between "2011-09-01 0:0:0" and "2011-12-31 23:59:59";
+}}}
+
+New evaluation
+{{{
+#!sql
+select * from events where created between "2011-09-01 0:0:0" and "2011-12-31 23:59:59";
+}}}
+
+New instructor 
+{{{
+#!sql
+select * from users where role LIKE "I" AND created between "2011-09-01 0:0:0" and "2011-12-31 23:59:59";
+}}}
+
+New student 
+{{{
+#!sql
+select * from users where role LIKE "S" AND created between "2011-09-01 0:0:0" and "2011-12-31 23:59:59";
+}}}
+
+Total student 
+{{{
+#!sql
+select * from users where role LIKE "S";
+}}}