I found that the book SQL Antipatterns helped me figure out some advanced SQL constructs. It presents a problem, shows the naive solution, takes apart that solu

I found that the book SQL Antipatterns helped me figure out some advanced SQL constructs. It presents a problem, shows the naive solution, takes apart that solution, and shows a better way.