[练习题]排序与分页

【题目】
1.查询员工的姓名和部门号和年薪，按年薪降序,按姓名升序显示


2.选择工资不在 8000 到 17000 的员工的姓名和工资，按工资降序，显示第21到40位置的数据


3.查询邮箱中包含 e 的员工信息，并先按邮箱的字节数降序，再按部门号升序

1.查询员工的姓名和部门号和年薪，按年薪降序,按姓名升序显示

SELECT last_name, department_id, salary * 12 AS "annual_salary"
FROM employees
ORDER BY annual_salary DESC, last_name ASC; 

2.选择工资不在 8000 到 17000 的员工的姓名和工资，按工资降序，显示第21到40位置的数据

SELECT last_name, salary
FROM employees
WHERE salary NOT BETWEEN 8000 AND 17000
ORDER BY salary DESC
LIMIT 20,20;

3.查询邮箱中包含 e 的员工信息，并先按邮箱的字节数降序，再按部门号升序
错误：

//error
SELECT last_name, email,SUM(email) AS sEmail, department_id
FROM employees
# WHERE email LIKE '%e%'
WHERE email REGEXP '[e]'
ORDER BY sEmail DESC, department_id ASC; 

正确：

SELECT last_name, email, department_id
FROM employees
WHERE email LIKE '%e%'
ORDER BY LENGTH(email) DESC, department_id;