I want to know how to write the query to run efficiently.
if the count is
0, return just the count (zero)
else, return the formatted string
I believe I'm calling the count multiple times and I want to see if there's a better way to do this.
WHEN 0 THEN '0'
ELSE '<a href="link here/" + Count(ItemID) + ">here</a>"'