# I need help in performing mathematical operations on the arguments I have selected in SQL

Advertisements select r.id, r.name, sum(p.crop_area) as crop_area_sum, sum(p.total_gross) as total_gross_sum total_gross_sum*10/crop_area_sum as total_normative from placement p right join region r on p.region_id = r.id where r.region_type = 2 and r.parent_id = 255 group by r.id; In the above code, I want to use the variables I got as crop_area and gross_product without summing again to… Read More I need help in performing mathematical operations on the arguments I have selected in SQL