another way around is to just cast COUNT(*)::integer

This has absolutely worked for me! Thank you, sir!
You saved me another 3 hours of my life.

I don't think it wants the answer ordered in any way, just displayed

The best way to understand it，Thank you for your interpretation
最好的理解方式

Bruh, your solution is exactly the same

LoOkS LiKe YoU SoLvEd It AlR

Story of our lives as developers :P

"This VIEW is used by a sales store to give out vouches to members who have spent over $1000 in departments that have brought in more than $10000 total, ordered by the members id."
So not all members with > 1000 should be included. Only the members that bought over $1000 worth of products in the selected departments (sold over $10000 worth of products).

try use bigint as your datatype for ok,bad and good and text for the name

The same problem.

PG::SyntaxError: ERROR: return and sql tuple descriptions are incompatible

Hi.

I have the same error message, I have no idea what's the problem. Some suggestion?

Fixed

Sigh, spoilers...