Only show results greater than a certain number when summing two values together
Try:

HAVING 100*((sum(COMMISSION/100)) / (SUM(AMOUNT/100))) &gt; 4


However you will still probably find that integer math is preventing you from getting the result you want. So this might be better:

HAVING 100*((1.0*sum(COMMISSION/100)) / (1.0*SUM(AMOUNT/100))) &gt; 4