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.
mmmmmmm ... there are many ways to resolve this task without using subqueries. I dont think this is a "best practices".
I also guess the instruction was not clear enough
I'm exploiting a defecting in your testing to pass this. I suggest you improve the test harness.
There is no advantage and this is not at all best practice, it just makes the query less readable.
The sql optimizer is so good that in 99.99999999999% of cases you never have to think about optimization, only readability.