I've looked at some of the answers here, and I keep getting stuck. I'm a brand new beginner.

I have a simple select statement

```
SELECT (100.0*(CURRENRL)/(CAPACITY)) AS "OCCUPANCY RATE"
FROM COURSE, LOCATION
WHERE LOCATION.LOCID=COURSE.LOCID

```

returns a column

```
90.000000000000
100.000000000000
80.000000000000
100.000000000000
100.000000000000
59.523809523809
66.666666666666
28.571428571428
76.190476190476
83.333333333333
23.333333333333

```

I'm just trying to round to the nearest whole number.

Such that I get output like:

```
90
100
80
100
100
60
67
...

```

I've tried to use ROUND and CAST, but end up with errors every time. I can post the errors if necessary, but my guess is that this should be simple and I'm missing some formatting or similar from the other questions I've looked at here on SO.

If I do:

```
ROUND(100.0*(CURRENRL)/(CAPACITY), 0) AS "OCCUPANCY RATE"

```

I get a lot of decimal places.

If I do:

```
ROUND(100*(CURRENRL)/(CAPACITY), 0) AS "OCCUPANCY RATE"

```

I get a nice whole integer, but it doesn't seem to round correctly. For instance, I get 59 instead of 60 for the 6th number, and 66 instead of 67 for the 7th number, etc.