Popular Holdshelf Aliases

popular_holdshelf_aliases.sql

-- popular holdshelf aliases at org unit 22 and its descendants
SELECT COUNT(*), UPPER(alias) AS alias
FROM actor.usr au
WHERE alias <> ''
AND alias IS NOT NULL
AND home_ou IN (SELECT id FROM actor.org_unit_descendants(22))
GROUP BY UPPER(alias)
HAVING COUNT(*) > 1
ORDER BY COUNT(*), UPPER(alias);


--  count |   alias
-- -------+------------
--      2 | CATWOMAN
--      2 | THE DOCTOR
-- (2 rows)