$ pnpm -s db:test
# cwd /Users/king/Desktop/Workspace/SRO/zoen
# exit 1

/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/010_surface.sql .... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/020_rbac.sql ....... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/030_audit.sql ...... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/040_admin_aux.sql .. ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/050_cms.sql ........ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/060_community.sql .. ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql .. 
Dubious, test returned 3 (wstat 768, 0x300)
Failed 2/7 subtests 
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/080_quality.sql .... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/090_staff.sql ...... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/100_push.sql ....... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/110_approvals.sql .. ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/120_sessions.sql ... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/130_ops.sql ........ ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/140_ai.sql ......... ok
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/150_support.sql .... ok

Test Summary Report
-------------------
/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql (Wstat: 768 (exited 3) Tests: 5 Failed: 0)
  Non-zero exit status: 3
  Parse errors: Bad plan.  You planned 7 tests but ran 5.
Files=15, Tests=149,  0 wallclock secs ( 0.05 usr  0.02 sys +  0.09 cusr  0.05 csys =  0.21 CPU)
Result: FAIL
Connecting to local database...
psql:/Users/king/Desktop/Workspace/SRO/zoen/packages/db/supabase/tests/070_analytics.sql:21: ERROR:  more than one row returned by a subquery used as an expression
error running container: exit 1