Try: select business_name, sum(points_awarded) from the_table group by business_name order by business_name You have to have the business_name in the result set (list of selected fields) in order to group or order by it.