Removed npi from the group by constraint for getting distinct providers; Modified constraint for getting procedures to get max(x_record_num instead of procedure_occurrence_source_identifier; Cleaned up where clause for getting observation_labs and vitals
Committing unsave changes
Committing unsaved changes