calculate an avg with no decimals

mysql, sql

Solution

SELECT 
    `TC Code`, 
    round(AVG(ALW_AMT),0) AS AVG_AMT
FROM 
    OFFICE_Claims_Physicians
GROUP BY 
    `TC Code`
ORDER BY 
    `TC Code`;

Problem

I wish I could figure this out. I need to produce a table with an average called AVG_AMT (integer) and has no decimals. It can either round or truncate. It really does not matter for this table. This what I have tried to write: ``` SELECT `TC Code`, AVG(ALW_AMT) as int(8,0) AS AVG_AMT FROM OFFICE_Claims_Physicians GROUP BY `TC Code` ORDER BY `TC Code`; ``` Any suggestions?

Original source