• Article Type: General
• Product: Aleph

Description:
Is there an SQL command we can use to determine how many new patrons of each patron type have been added to our database since a certain date or between certain dates?

We would like to know how many new patrons of each patron type we have registered since opening our new facility last September.

Resolution:
The following SQL can be used to get you this count:

> s+ abc50
SQL> select z305_bor_status, count(*) from z305 where z305_open_date >= '20080901' group by z305_bor_status;