[文件] sql問題
這是別人的sql作業題目:
List the maker and model number of all planes that can be flown by a pilot in the database, along with the salary range (maximum and minimum salaries) of the pilots who can fly that plane.
(閱讀全文)
List the maker and model number of all planes that can be flown by a pilot in the database, along with the salary range (maximum and minimum salaries) of the pilots who can fly that plane.
List all departure dates and numbers, along with the total crew (ass
employee) salary cost divided by the number of booked passengers, in
decreasing cost order. If there are no passengers booked on a depart
no employees assigned ignore that departure.
我有把他翻成中文，是：
列出所有航班的時間與編號，與整架飛機上機組員的薪水除以簽入的乘客總數，
若航班無機組員或乘客，就不列出。
Find the names of all pilots who are assigned to a departure using a
the pilot is not known to be able to fly.
找出所有飛行員不會飛行班所指派的飛機的飛行員名稱。
謝謝你！：）
找出所有被指派到該班次的駕駛員 但不會行駛此飛機的
這樣比較順
memo: 沒幫忙解出來後續 懶懶的
要先從Assigned_To 裡面去抓職員分配到那個日期的那各班次
再去判斷那各班次的飛機是哪台
然後在判斷 那個職員能不能飛那台班機
« [freebsd] lftp安裝與應用 | Main | [dreamhost] 整理一下 »
迴響 |
0 引用
