Calculate percentage between two columns in SQL Query as another column

Try this:

SELECT availablePlaces, capacity, 
       ROUND(availablePlaces * 100.0 / capacity, 1) AS Percent
FROM mytable

You have to multiply by 100.0 instead of 100, so as to avoid integer division. Also, you have to use ROUND to round to the first decimal digit.

Demo here

The following SQL query will do this for you:

SELECT availablePlaces, capacity, (availablePlaces/capacity) as Percent 
from table_name;

Related