/* Numeric functions */

SELECT course_id, description, SIGN(price)
FROM   course;

SELECT course_id, price, CEIL(price * 1.05) 
FROM   course;

SELECT course_id, price, FLOOR(price * 1.05) 
FROM   course;

SELECT course_id, price, ROUND(price * 1.05, 2) 
FROM   course;

SELECT course_id, price, TRUNCATE(price * 1.05, 2) 	/* for Oracle use */
FROM   course;						/* TRUNC(..)     */

SELECT student_id, POWER(student_id, 2), POWER(2, 8) 
FROM   student;

SELECT student_id, SQRT(student_id)
FROM   student;

SELECT student_id, RAND( )
FROM   student;

SELECT student_id, SQRT( POWER(student_id, 2))		/* nested */ 
FROM   student;