[DB] Add member points to member view about astro-api HOT 3 CLOSED

So I first added a few entries to the member_point_transaction table as a quick test, and then I changed the member view code to left join with the member_point_transaction table based on contact_id. In order to use aggregate functions, I added the group by line so that the points will group based on the contact_id. Finally I just added the points field to the view and set it to the sum of each contact's points found in the member_point_transaction table. I used the coalesce() function so that instead of anyone's points being [NULL], it will just return as 0 instead.

Old member view code:

New member view code:

Example member_point_transaction rows:

Member view results:

from astro-api.

Link to new Member View SQL:
https://drive.google.com/file/d/1pf4djsVKuXFXJ3GtSSFIMTPffQjwoNh_/view?usp=sharing

Link to new Active Member View SQL:
https://drive.google.com/file/d/1uBYXd0tHgW87hyyV5rhb60kcTUJ-FAAr/view?usp=sharing

from astro-api.

Changes to the SQL code have been uploaded to our Google Drive. Great work Ben!

from astro-api.