SELECT first_name, last_name, hire_date, CASE (2000 - CAST(strftime('%Y',hire_date) AS INTEGER)) WHEN 1 THEN '1 年' WHEN 3 THEN '3 年' WHEN 5 THEN '5 年' WHEN 10 THEN '10 年' WHEN 15 THEN '15 年' WHEN 20 THEN '20 年' WHEN 25 THEN '25 年' WHEN 30 THEN '30 年' END aniversary FROM employees ORDER BY first_name;
SELECT first_name, last_name, CASE WHEN salary < 3000 THEN '低' WHEN salary >= 3000 AND salary <= 5000 THEN '中' WHEN salary > 5000 THEN '高' END evaluation FROM employees;
SELECT * FROM countries;
SELECT * FROM departments;
SELECT * FROM dependents;
SELECT * FROM employees;
SELECT * FROM jobs;
SELECT * FROM locations;
SELECT * FROM regions;
