Get row Sums across multiple users/tables

I am working in SQL Server, and I have three tables that I have simplified below

USERS:

UserId  | FirstName | LastName  | Email
--------+-----------+-----------+------------------
1       |    Joe    | Johnson   | [e-mail]
2       |   Mary    | Smith     | [e-mail]

POINTS:

UserId  | PointsEarned
--------+--------------
1       |   25
2       |   50
1       |   50
1       |   10
2       |   20

CLAIMS:

UserId | PointsUsed
-------+-----------
1       |   50
2       |   20
1       |   10
1       |   10
2       |   5

I’m trying to run a report of distinct users with a sum of points earned and a sum of points used. I’ve started with the join of tables by userId…

SELECT  
    Users.UserId, Users.FirstName, Users.LastName, Users.Email, 
    Points.PointsEarned, Claims.PointsUsed
FROM
    Users 
INNER JOIN
    Points ON Points.UserId = Users.UserId 
INNER JOIN
    Claims ON Users.UserId = Claims.UserId

but of course that returns the user multiple times, I’ve tried many variations of Group By, Distinct, etc but can’t seem to get there. Users are (in theory) already distinct by Id or email, the entries into the other two tables are dozens up to hundreds per user.

Desired output would be something like this

UserId  | FirstName | LastName  | Email             | PointsEarned  | PointsUsed
1       |    Joe    | Johnson   | [e-mail] |   85          |   70
2       |   Mary    | Smith     | [e-mail]   |   70          |   25 

Any help is appreciated.

Answer

Try it with subqueries and LEFT JOINS in case there are Users without points.

select u.userid, u.firstname, u.lastname, u.email, p.pointsearned, c.pointsused
from [users] u
left join (Select userid,sum(pointsearned) as pointsearned from points group by userid) p on u.userid=p.userid
left join (Select userid,sum(pointsused) as pointsused from claims group by userid) c on u.userid=c.userid
order by u.userid, u.firstname, u.lastname, u.email