My brain! My brain!

Any SQL experts online tonight? Help!

( sql conundrum )

Edit: It works! Woo! Thanks, syleth, ruudboy and mooism for all giving the right answer with spooky speed...