Help with SQL

[mistrpug]

Thanks a lot. It's not a real DB, a buddy of mine at work came across this problem while trying to brush up on his SQL and neither of us could figure it out. Thanks again. Nice work.