midterm-{期中考}
Authored by Chun-Jung Lin
others
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
OPEN ENDED QUESTION
30 sec • Ungraded
班級
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
30 sec • Ungraded
學號
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
30 sec • Ungraded
姓名
Evaluate responses using AI:
OFF
4.
OPEN ENDED QUESTION
30 sec • Ungraded
請寫出可以找出90年10月上旬和下旬，以現場掛號就診、掛號費為零之病患病歷號、看診科別及日期的SQL。
Evaluate responses using AI:
OFF
5.
OPEN ENDED QUESTION
30 sec • Ungraded
請寫出可以算出91年二月每個有病患掛號的科別，每個科平均可以分配到多少部分負擔和掛號費(兩者之和)金額的SQL。(例如：若部分負擔和掛號費的總合為10000元，有4個科有病患掛號，則平均每個科可分配到2500元。
Evaluate responses using AI:
OFF
6.
OPEN ENDED QUESTION
30 sec • Ungraded
請寫出可以找出91年度第一季的每個月下旬，有哪些女性員工掛號掛號看診的SQL。
Evaluate responses using AI:
OFF
7.
OPEN ENDED QUESTION
30 sec • Ungraded
請寫出計算出90年10月每週四的夜間門診，有哪些病患曾來掛號看診的SQL。
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
