ROUND, CEIL, FLOOR in SQL - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Output of ROUND function with decimal places

What is the output of the following SQL query?

SELECT ROUND(123.4567, 2) AS rounded_value;

SQL

SELECT ROUND(123.4567, 2) AS rounded_value;

A 123.45

B 123.46

C 123.5

D 124

💡 Hint

ROUND rounds the number to the specified decimal places.

ROUND(123.4567, 2) rounds the number to 2 decimal places, so 123.4567 becomes 123.46.

❓ query_result

intermediate

Output of CEIL function on a negative decimal

What is the output of this SQL query?

SELECT CEIL(-3.7) AS ceil_value;

SQL

SELECT CEIL(-3.7) AS ceil_value;

A -3

B -4

C -3.7

D -2

💡 Hint

CEIL returns the smallest integer greater than or equal to the number.

CEIL(-3.7) returns -3 because -3 is the smallest integer greater than or equal to -3.7.

❓ query_result

advanced

Combining FLOOR and ROUND functions

What is the output of this SQL query?

SELECT FLOOR(ROUND(5.67, 0)) AS result_value;

SQL

SELECT FLOOR(ROUND(5.67, 0)) AS result_value;

A 6

B 5

C 7

D 5.67

💡 Hint

ROUND first rounds 5.67 to 6, then FLOOR returns the largest integer less than or equal to 6.

ROUND(5.67, 0) rounds to 6, and FLOOR(6) returns 6.

📝 Syntax

advanced

Identify the syntax error in CEIL usage

Which option contains a syntax error when using the CEIL function in SQL?

A SELECT CEIL(4.2) FROM dual;

B SELECT CEIL(-1.5);

C SELECT CEIL(4.2) AS ceil_val;

D SELECT CEIL 4.2 FROM dual;

💡 Hint

Functions require parentheses around their arguments.

Option D is missing parentheses around the argument, causing a syntax error.

🧠 Conceptual

expert

Understanding FLOOR behavior with negative numbers

Which statement best describes the behavior of the FLOOR function when applied to negative decimal numbers?

A FLOOR rounds the number towards zero, so FLOOR(-2.3) returns -2.

B FLOOR returns the largest integer less than or equal to the number, so FLOOR(-2.3) returns -2.

C FLOOR returns the largest integer less than or equal to the number, so FLOOR(-2.3) returns -3.

D FLOOR always returns the absolute value of the number rounded down, so FLOOR(-2.3) returns 2.

💡 Hint

Think about the number line and what 'less than or equal' means for negative numbers.

FLOOR returns the largest integer less than or equal to the input. For -2.3, the largest integer less than or equal is -3.