Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
As others said the wording on this is somewhat difficult to parse. Instead of
"This VIEW is used by a sales store to give out vouches to members who have spent over $1000 in departments that has brought in more than $10000 total ordered by the members id. "
What about:
"This VIEW is used to give out vouches to members who spent over $1,000 in departments that have sales of over $10,000. Results should be ordered by member id ascending."
This comment is hidden because it contains spoiler information about the solution
In the table diagram on Customers the customer_id is an int4, but on payment customer_id is int2 (int vs smallint). Won't the system fail if a customer with ID larger than 32,767 submits a payment?