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;
