As you have seen only one row was returned for each of the queries. We can also combine these grouping functions in the one statement. The last two of the mathematical functions that we will discuss here are ceil and floor. The best way to visualize the way these functions are used is to think in terms of the floor and ceiling in your house or apartment. If our number is 1.2 and we use the function floor, the next whole number below it would be 1 and if we used the function ceil the next whole number above it would be 2.
Lets try the following statement.
We can combine both functions in the one statement.