20Q2 - Delete classa_complete and classa_incmpl and create units_co field

[AmandaDoyle]

• Delete the classa_complete and classa_incmpl fields.

• Create a new field called units_co located after otherb_prop that is populated with the number of units from the most recent certificate of occupancy. (co_latest_units as units_co)

[SPTKL]

Down stream impact:

• JOBNUMBER_co_prop_mismatch in qaqc_mid.sql

  
  JOBNUMBER_co_prop_mismatch AS (
  SELECT job_number
  FROM MID_devdb
  WHERE job_type = 'New Building' 
  AND classa_complt::numeric - classa_prop::numeric > 50
  ),