The part that doesn't work is the

where

clause on

conflicts

How do you do a where clause within aggregate count?