NEW
Font size
WorksheetsSQL問題①
Total questions: 10
Worksheet time: 5mins
Staffテーブルから、全スタッフの名前（`name`）と部署（`department`）を取得する正しいクエリはどれですか？
SELECT * FROM Staff;
SELECT name, department FROM Staff;
SELECT name AND department FROM Staff;
GET name, department FROM Staff;
部署（`department` = 'Development'）に所属するスタッフのレコードだけを抽出する`WHERE`句はどれですか？
WHERE department IS 'Development';
WHERE department = 'Development';
FILTER department = 'Development';
WHERE department LIKE 'Development';
給与（`salary`）が500,000以上のスタッフを全員表示する正しいクエリはどれですか？
SELECT * FROM Staff WHERE salary >= 500000;
SELECT * FROM Staff WHERE salary > 500000;
SELECT * FROM Staff WHERE salary = 500000;
SELECT * FROM Staff HAVING salary >= 500000;
スタッフを給与（`salary`）が高い順に並べ替えて表示するクエリはどれですか？
SELECT * FROM Staff SORT BY salary DESC;
SELECT * FROM Staff ORDER BY salary;
SELECT * FROM Staff ORDER BY salary DESC;
SELECT * FROM Staff GROUP BY salary DESC;
営業部（`department` = 'Sales'）に所属し、かつ役職（`role`）が'Manager'であるスタッフを抽出するクエリはどれですか？
SELECT * FROM Staff WHERE department = 'Sales' OR role = 'Manager';
SELECT * FROM Staff WHERE department = 'Sales' AND role = 'Manager';
SELECT * FROM Staff WHERE department = 'Sales', role = 'Manager';
SELECT * FROM Staff WHERE department = 'Sales' WHERE role = 'Manager';
人事部（`department` = 'HR'）のスタッフの人数を数える正しいクエリはどれですか？
SELECT NUMBER(*) FROM Staff WHERE department = 'HR';
SELECT SUM(staff_id) FROM Staff WHERE department = 'HR';
SELECT COUNT(*) FROM Staff WHERE department = 'HR';
SELECT * FROM Staff WHERE department = 'HR' COUNT();
結果の列名を`name`から`Employee Name`に、`salary`から`Salary`に変更して表示するクエリはどれですか？
SELECT name RENAME 'Employee Name', salary RENAME 'Salary' FROM Staff;
SELECT name, salary FROM Staff ALIAS 'Employee Name', 'Salary';
SELECT name AS 'Employee Name', salary AS 'Salary' FROM Staff;
SELECT 'Employee Name' = name, 'Salary' = salary FROM Staff;
`Staff`テーブルに存在する部署（`department`）の種類を、重複なく一覧表示するクエリはどれですか？
SELECT UNIQUE department FROM Staff;
SELECT department FROM Staff GROUP BY department;
SELECT DISTINCT department FROM Staff;
SELECT ALL department FROM Staff;
名前（`name`）に'a'という文字が含まれるスタッフを検索する正しいクエリはどれですか？
SELECT * FROM Staff WHERE name LIKE '%a%';
SELECT * FROM Staff WHERE name = '%a%';
SELECT * FROM Staff WHERE name CONTAINS 'a';
SELECT * FROM Staff WHERE name LIKE '_a_';
各部署（`department`）の平均給与（`salary`）を計算するクエリはどれですか？
SELECT department, AVG(salary) FROM Staff;
SELECT department, AVG(salary) FROM Staff GROUP BY department;
SELECT department, AVERAGE(salary) FROM Staff GROUP BY department;
SELECT department, AVG(salary) FROM Staff ORDER BY department;
