Teradata SQL 线性回归函数

 基于budget_amounts排队得到前三个部门，显示部门号和预算？

SELECT department_number,
       salary_amount,
       RANK(salary_amount) AS Rank
FROM dapartment
QUALIFY RANK(salary_amount) <= 3;

 基于总budget_amounts排队得到前三个部门，显示部门号和预算？

SELECT deptno,
       salamt,
       RANK(salamt) AS ranked
FROM (SELECT department_number,
             SUM(salary_amount)
      FROM employee GROUP BY 1) temp (deptno,salamt)
QUALIFY RANK(salamt) <= 3;