I don't like those challenges because they teach the wrong thing. There are many times where the resolution of a problem using a single query is just flat out the wrong thing to do for scalability and/or performance.
--Jeff Moden
Change is inevitable... Change for the better is not.