An assistant wrote the view in answer.sql, which counts collections per artist. Read it first, then run it and compare with the expected result below. Fix the view inside the transaction.
Expected once fixed: Chen Wei has 1 active collection. The shipped view says 2, and still returns 3 rows.