Worksheets3_Ch6_S1
Total questions: 5
Worksheet time: 3mins
下列哪項SQL語句會從「Clients」資料表中提取居住於「Sha Tin」以及年齡大於25歲的客戶的數據？
SELECT * FROM Clients WHERE district = 'Sha Tin' AND age > 25;
SELECT * FROM Clients WHERE district = 'Sha Tin' OR age > 25;
SELECT * FROM Clients WHERE district = 'Sha Tin' AND age >= 25;
SELECT * FROM Clients WHERE district = 'Sha Tin' OR age >= 25;
考慮以下「Staff」資料表的模式，並回答接續的問題。
下列哪項SQL語句會為銷售部（Sales Department）員工增加1,000元薪酬？
UPDATE Staff SET salary = salary + 1000;
UPDATE Staff ADD 1000 TO salary WHERE department = 'Sales';
UPDATE Staff SET salary = salary + 1000 WHERE department = 'Sales';
UPDATE Staff ADD salary BY salary + 1000 WHERE department = 'Sales';
以下展示「Student」資料表內的部分記錄。
下列哪項SQL語句用於求得有多於20名學生修讀的學系的學生人數？
SELECT department, COUNT(*) FROM Student
GROUP BY department HAVING COUNT(*) > 20;
SELECT department, COUNT(*) > 20 FROM Student
GROUP BY department;
SELECT department, COUNT(*) FROM Student
WHERE COUNT(department) > 20 GROUP BY department;
SELECT department, COUNT(*) FROM Student
WHERE COUNT(*) > 20
GROUP BY department;
下列哪項函數用來計算資料表中欄位的平均值？
AVG(*)
AVG(fieldname)
AVERAGE(fieldname)
COUNT(fieldname)
下列哪項SQL語句能列出某資料表中所有的欄位和記錄？
SELECT ALL FROM tablename;
SELECT $ FROM tablename;
SELECT % FROM tablename;
SELECT * FROM tablename;
