framework/resources/Functional/hive/hive_functions/char_groupby.q

select sum(contributions) as col1, count(registration) as col2, registration from voter_text where registration <> 'green' group by registration order by registration;