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
asked
How to apply PIVOT to this group by query
23 People are following this question.
