Selecting the Highest Count for a Categorical Variable When Grouping in Hive SQL: A Step-by-Step Solution