SQL Return Percentage

Question

Trying to create a query which will send me back the percentage of USER_TOT_REQS.

How do I get the result back with decimals?

SELECT  u.USER_NAME
    ,SUM(t.REQ_AMOUNT) as 'USER_TOTAL_AMOUNT'
    ,COUNT(t.ID) as 'USER_TOT_REQS'
    ,(COUNT(t.ID)* 100 / (Select COUNT(*) from TB__TOMBSTONES t 
    JOIN TB__USERS u 
    ON u.ID = t.CURRENT_BUYER__ID
        WHERE 1=1
        AND t.REGION__ID = 1
        AND t.OFFICE__ID = 1
        AND t.STL_ASSIGNED__ID = 8)) AS 'Percentage'
FROM TB__TOMBSTONES t 
    JOIN TB__USERS u 
    ON u.ID = t.CURRENT_BUYER__ID
WHERE 1=1
AND t.REGION__ID = 1
AND t.STL_ASSIGNED__ID = 8
GROUP BY u.USER_NAME
ORDER BY USER_TOTAL_AMOUNT DESC

Basing myself on a few examples I've seen on stackoverflow - Thanks.

Answer 1

To get decimal values, change your 100 to 100.0, otherwise everything is implicitly treated as an INT.