How to apply PIVOT to this group by query
select hosp_type, adm_type, count(*) as cnt from raw.stacked_prime group by hosp_type, adm_type
how do I convert this to show hosp_type as columns, admit_type as rows, and its count filled in the table? Tried multiple ways no luck
