skema yang digunakan adalah HR practice oracle Fundamental 1
Soal :
Find the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number.
jawab:
SELECT ROUND(MAX(SALARY),0) "Maximum",
ROUND(MIN(SALARY),0) "Minimum",
ROUND(SUM(SALARY),0) "Sum",
ROUND(AVG(SALARY),0) "Average"
FROM employees;
catatan : ingat ketika membuat concat harus kutip 2 (")
Soal :
Find the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number.
jawab:
SELECT ROUND(MAX(SALARY),0) "Maximum",
ROUND(MIN(SALARY),0) "Minimum",
ROUND(SUM(SALARY),0) "Sum",
ROUND(AVG(SALARY),0) "Average"
FROM employees;
catatan : ingat ketika membuat concat harus kutip 2 (")
