SQL 講義1手寫

Question 1

取出位於巴黎的供應商號碼及狀態
______________________
from s
where city=’paris’

Accepted Answer

select s_no, status

Accepted Answer

select s_no, s_status

Question 2

取出位於巴黎的供應商號碼及狀態
select s_no,status
______________________
where city=’paris’

Accepted Answer

from s

Question 3

取出位於巴黎的供應商號碼及狀態
select s_no,status
from s
______________________

Accepted Answer

where city='paris'

Question 4

取出位於巴黎的供應商號碼及狀態 (限定的欄位名稱)
______________________
from s
where city=’paris’

Accepted Answer

select s.s_no, status

Accepted Answer

select s.s_no, s.s_status

Question 5

從table_name表中:s_no 改名叫 s_status
_________________________
from table_name;

Accepted Answer

select s_no s_status

Question 6

從table_name表中:s_no 改名叫 s_status
select s_no s_status
__________________________

Accepted Answer

from table_name;

Accepted Answer

from table_name

Question 7

選擇部門名稱，並計算每個部門的人數（命名為 total）
_____________________________
from employees 
where salary > 30000 
group by department -- 依部門進行分組
having count(*)>3
order by total desc;

Accepted Answer

select department, count(*) as total

Question 8

從 employees（員工）資料表中查詢
select department, count(*) as total
_____________________________
where salary > 30000 
group by department 
having count(*)>3
order by total desc;

Accepted Answer

from employees