I am trying to create a graph where the x-axis is the "REASON_FOR_SCRAP" column from my table, and the Y-axis is the sum of the values from the "CHARGED_COST" column. This is where my code is at this moment, hoping someone would be able to figure it out:

    select sum(SCRAP_BODY_SYSTEM.CHARGED_COST) as CHARGED_COST,
        SCRAP_BODY_SYSTEM.REASON_FOR_SCRAP as REASON_FOR_SCRAP 
    from SCRAP_BODY_SYSTEM SCRAP_BODY_SYSTEM
    group by SCRAP_BODY_SYSTEM.REASON_FOR_SCRAP

For some reason each data entry per a category shows up as another bar instead of summing into the same bar for each category like shown below:

What is weird is if I change it to a pie chart it sums up all the values normally.