SELECT D.Name AS Department,
E.Name AS Employee,
E.Salary AS Salary
FROM Employee E
INNERJOIN Department D
ON E.Departmentid = D.Id
WHERE Salary >=(SELECTMax(Salary)FROM Employee E2
WHERE E.Departmentid = E2.Departmentid
)
任务二
SELECT(CASEWHEN id =(SELECTCOUNT(*)FROM seat)THEN id
WHENMOD(id,2)=0THEN id -1ELSE id +1END)AS id ,student
FROM seat
ORDERBY id
任务3
SELECT*,(SELECTCOUNT(DISTINCT Score)FROM score AS s2
WHERE s1.Score < s2.Score
)+1AS"RANK"###因为是数字列转为字符串,所以添加字符串 FROM score AS s1
ORDERBY Score DESC