Differences

This shows you the differences between two versions of the page.

--- evergreen-reports:sql:borrower:statistical_reports [2011/03/08 22:11] – created bshum
+++ evergreen-reports:sql:borrower:statistical_reports [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 11: / Line 11: @@
 Run this report any time in the month directly following the month you would like to capture statistics for.
---------------------------------------------------------------
+<code sql>
  SELECT aou.name AS "Library", pgt.name AS "Profile", asceum.stat_cat_entry AS "Residency", count(pgt.name) AS "Count"
    FROM actor.usr au
@@ Line 22: / Line 23: @@
   GROUP BY aou.name, pgt.name, asceum.stat_cat_entry
  UNION
@@ Line 35: / Line 35: @@
  ORDER BY 1, 2, 3;
+</code>
-------------------------------------
 Back to [[evergreen-reports:sql:borrower|Borrower Reports]] page