Having problems joining table
When you use the GROUP BY clause, you can only select the fields you group on, or aggregate functions on top of ungrouped fields, like so for example:
Select name, address, dob, sum(scores)
From Emp e
JOIN Emp_Players ep ON e.empID = ep.eid 
JOIN Plays p ON p.pid = ep.pid
Group by p.pid, name, address, dob

This will give you the sum of the scores for that player (pid) as you want if they only have one name, address, and dob per pid. But if they have two addresses for example, you'll see two records for that pid, one for each address, with the score summed for just that address. (I assume that's not the case here but just so you're aware. I was unsure since the schema you provided is incomplete and doesn't mention address.)