作者s27492350 (money)
看板Database
標題[SQL ]報告上不會的問題
時間Sun Mar 28 18:12:47 2010
這是我學校報告上的問題跟OUTPUT的表格,現在就是要以題目跟表格來打出
SQL的編程語言,可是我不知道怎樣著手!(注意)題目跟表格都是英文的
所以請各位幫幫忙~我已經想很久了可是就是不對,因為我用的是ISQL網上的系統
所以如果輸入的編程不對的話,就不會有表格出現。拜託高手救救小弟!
Q:List the columns displayed below for all rows of the staff table.
The rows must show each staff member's name and the state they were trained at.
The output must be in state name sequence. Within each state, rows must be listed within
staff name sequence.
Output of Part 1
SURNAME FIRSTNAME STATENAME
--------------- --------------- --------------------
Avery Steve New South Wales
Fato Johnny New South Wales
Vasa Mansi Queensland
Clinch Alice South Australia
Bright Rosemary Tasmania
Ho Kevin Tasmania
Cross Chris Victoria
Davies Rose-Mary Victoria
Davis Mary Victoria
Jones Jeremy Victoria
Ng Lee-Li Victoria
Q2:List the columns displayed below from the staff table.
Only list females who were trained in Victoria or Tasmania.
The rows must be listed in ascending staff name sequence
Output of Part 2
STAFFID SURNAME FIRSTNAME GENDER TRAINDEDSTATE FLOORNO OFFICENO FOOTBALLTEAM
249 Bright Rosemary F T 1 2 St.Kilda
351 Davies Rose-Mary F V 1 1 Collingwood
511 Davis Mary F V 1 3
170 Ng Lee-Li F V 2 2
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 123.243.53.205