Great post for refreshing SQL!
I assume points are only counted once a customer becomes a member (refer #10). Your solution for #9 should consider the join date for customers and count points only after they've become members.