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

Challenge - 5 Problems

❓ query_result

intermediate

Output of ROUND function with decimals

What is the output of the following MySQL query?

SELECT ROUND(12.3456, 2) AS rounded_value;

MySQL

SELECT ROUND(12.3456, 2) AS rounded_value;

A 12

B 12.34

C 12.346

D 12.35

💡 Hint

ROUND rounds the number to the specified decimal places.

ROUND(12.3456, 2) rounds the number to 2 decimal places, so 12.3456 becomes 12.35.

❓ query_result

intermediate

Output of CEIL function with negative decimal

What is the output of this MySQL query?

SELECT CEIL(-3.7) AS ceil_value;

MySQL

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

Output of FLOOR function with positive decimal

What is the output of this MySQL query?

SELECT FLOOR(7.999) AS floor_value;

MySQL

SELECT FLOOR(7.999) AS floor_value;

A 7.999

B 8

C 7

D 0

💡 Hint

FLOOR returns the largest integer less than or equal to the number.

FLOOR(7.999) returns 7 because 7 is the largest integer less than or equal to 7.999.

🧠 Conceptual

advanced

Difference between CEIL and FLOOR for negative numbers

Which statement correctly describes the difference between CEIL and FLOOR functions when applied to negative decimal numbers in MySQL?

A CEIL rounds towards zero, FLOOR rounds away from zero.

B CEIL returns the smallest integer greater than or equal to the number, FLOOR returns the largest integer less than or equal to the number.

C CEIL and FLOOR both round up for negative numbers.

D CEIL and FLOOR both round down for negative numbers.

💡 Hint

Think about how CEIL and FLOOR behave on negative decimals.

CEIL returns the smallest integer greater than or equal to the number, which for negative numbers means rounding up towards zero. FLOOR returns the largest integer less than or equal to the number, which means rounding down away from zero.

📝 Syntax

expert

Identify the syntax error in ROUND usage

Which option contains a syntax error when using the ROUND function in MySQL?

A SELECT ROUND(15.678 1);

B SELECT ROUND(15.678, 1);

C SELECT ROUND(15.678);

D SELECT ROUND(15.678, 0);

💡 Hint

Check the syntax for function arguments and commas.

Option A is missing a comma between the number and the decimal places, causing a syntax error.