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.
I've got a solution that handles every part of the problem except the (if a customer ever rented an NC-17 movie). I can filter out all NC-17 movies from the total count, but am failing to think of a way to completely remove these customers without using a CTE or subquery. A hint would be appreciated.