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.
Good challenge, but the description is not very clear. Here's how I think it could be rewritten:
Presented below is a schema relating toys to a toy factory.
Table "toy_factory"
Table "toys"
Write a query that returns all the fields in
toy_factory
, counts the number of toys each factory has made (return the column as 'toy_count'), and groups these counts by the corresponding factory.