Rally Health interview question

SQL problems: Self join, percentage of column