i hate it when i'm dumber than absolutely necessary; no reason to group, just needed COUNT and the right WHERE clause