Tried code:
SELECT count(*) Count_people_inside_3miles
FROM CLIENT_DATA
WHERE (ABS(C_ADD_X) >=1 AND ABS(C_ADD_X) <=3) AND (ABS(C_ADD_Y) >=1 AND ABS(C_ADD_Y) <=3);
SELECT count(CLIENT_ID) Count_Total_people
FROM CLIENT_DATA;
Result:
| COUNT_PEOPLE_INSIDE_3MILES |
|---|
| 15 |
| COUNT_TOTAL_PEOPLE |
|---|
| 24 |
How do I calculate 15/24*100?
>Solution :
SELECT
CONVERT(VARCHAR(5), (COUNT_PEOPLE_INSIDE_3MILES / COUNT_TOTAL_PEOPLE) * 100) + '%' AS formatted_percentage
FROM (
SELECT count(*) COUNT_PEOPLE_INSIDE_3MILES
FROM CLIENT_DATA
WHERE (ABS(C_ADD_X) >=1 AND ABS(C_ADD_X) <=3) AND (ABS(C_ADD_Y) >=1 AND ABS(C_ADD_Y) <=3)
) t1,
(
SELECT count(CLIENT_ID) COUNT_TOTAL_PEOPLE
FROM CLIENT_DATA
) t2;
This will calculate the percentage of people inside 3 miles and return the result in a column called percentage.