re: #215 CuriousLurker
I wish I could help, and while I recognize that the second question requires a correlated subquery, I would have to stare at a few examples to get it right. I write a query like that about every 5 years. Even for your first question, I would have to scour the internet.
ETA: And then RBS comes up with something simpler.