Lab: Data Aggregation -> Average Salary
Lab: Data Aggregation -> Average Salary
Judge линк
Защо този код не минава в Judge?
select e.department_id,CAST(avg(e.salary) AS DECIMAL(6,2))as AverageSalary
from employees as e
group by e.department_id
order by e.department_id;
Този код минава с 100/100.
select e.department_id,ROUND(avg(e.salary) ,2)as AverageSalary
from employees as e
group by e.department_id
order by e.department_id;
Защо има само един тест в Judge за тази задача ?
На упражненията има 5 теста за всяка задача.
