Make endpoints for aggregates (by_state, by_size)

[lbeaufort]

Summary

Design ticket: #4175

3) /presidential/contributions/by_size/

(national map right side contribution size)
(DISCLOSURE.PRES_CA_CM_SCHED_LINK_SUM_20D / _16)
Filter: candidate_id, election_year

TODO: Consider using "size" filter like /schedules/schedule_a/by_size/ instead (in addition to? ) contribution_range_id

The total all contributions in the following ranges:

-0 $200 and under
-200 $200.01 - $499.99
-500 $500 - $999.99
-1000 $1000 - $1999.99
-2000 $2000 +

SELECT contb_range_id AS contribution_range_id, 
-- TODO: Add size? more readable for devs
ROUND(contb_receipt_amt) AS contribution_receipt_amount 
FROM DISCLOSURE.PRES_CA_CM_SCHED_LINK_SUM_20D
order by contb_range_id

===========================================================

4) /presidential/contributions/by_state/

(national map circle per candidate):
(view on DISCLOSURE.PRES_CA_CM_SCHED_A_JOIN_20D / _16
Filter: candidate_id, election_year

SELECT 
cand_id AS candidate_id, 
contbr_st as contributor_state,
contb_receipt_amt as contribution_receipt_amount,
election_yr as election_year
FROM
DISCLOSURE.PRES_CA_CM_SCHED_A_JOIN_20D
WHERE CONTBR_ST IN ('CA', 'NY', 'TX', 'FL', 'IL', 'VA', 'MA', 'DC', 'NJ', 'MD', 'PA', 'WA', 'CT', 'GA', 'CO', 'OH', 'AZ', 'NC', 'MI', 'TN', 'NM', 'MO', 'MN', 'OR', 'UT', 'WI', 'NV', 'SC', 'IN', 'OK', 'LA', 'AL', 'KY', 'AR', 'NH', 'IA', 'KS', 'HI', 'ME', 'MS', 'RI', 'DE', 'VT', 'ID', 'NE', 'MT', 'WV',  'AK', 'WY', 'SD', 'ND') 
AND ZIP_3 ='NA'
ORDER BY cand_id desc nulls first limit 100

Completion criteria

• Make views in database with migration (pair w/DB team)
• Make endpoints based on design
• Use a feature flag
• Add test coverage for new endpoints