Final-<期末考>

班級 Class

學號 Student Number

姓名 Name

請寫出一完整SQL，可以統計出醫院女性同仁身份證為A和M開頭且為巨蟹座 Cancer (06/22 - 07/22)且在90年12月有掛號的人數。

Please write a complete SQL query to count the number of female colleagues in a hospital whose ID numbers start with 'A' or 'M', are Cancers (06/22 - 07/22), and registered in December of the year 90.

請寫出一完整SQL，使用subquery 的Exists找出90年12月中旬，以現場掛號就診、部分負擔費為零，並亦曾在當月下旬以 現場 或 預約 方式就診之病患病歷號。(現場 = ‘1’、預約 = ‘2’)

Please write a complete SQL using a subquery with EXISTS to find the medical record numbers of patients who registered in person and had zero copayment in mid-December of the year 90, and also registered on-site or by appointment in late December of the same year. (on-site = '1', Appointment = '2')

請寫出可以算出91年五月，每個有病患掛號就診的時段，平均每個時段可以分配多少部分負擔和掛號費(兩者之和)金額的SQL。(例如：若部分負擔和掛號費的總合為10000元，有4種掛號方式被使用，則平均每個科可分配到2500元。

Please write an SQL query that can calculate the average amount of copayments and registration fees (sum of both) for each time slot in May of the year 91, for time slots that had patient registrations. (e.g., if the total amount of copayments and registration fees is 10,000 and 4 registration methods were used, each method should be allocated 2,500 on average).

請以一完整SQL找出90年12月份每天的夜間時段部分負擔現金收入，單日出現最高 的部分負擔現金收入及日期。

Please write a complete SQL to find the nightly cash copayment income for each day in December of the year 90, the single highest daily cash copayment income, and its date.

請以一完整SQL找出醫院女性員工 在90年及91年第四季 每種血型 的掛號人數統計。

Please write a complete SQL to find the number of registrations for female hospital employees for each blood type in Q4 of the year 90 and year 91.

請完成EMI課程問卷調查，並簡單說明問卷的內容(Bonus 5%)。

Completion of EMI Course Survey (Bonus 5%). (User’s response needed)

https://docs.google.com/forms/d/e/1FAIpQLSeFg3TyICa7udKPE3jy9j6Rm7k3cCMUy5YJF4ZlW_vahhzG4Q/viewform

本學期課程您還記得多少？您覺得您的學期成績應該得到幾分？對本學期課程您有哪些建議或心得？請簡單說明。(Bonus 10)

Reflection on the Semester’s Courses, Expected Grade, and Suggestions (Bonus 10%): (User’s response needed)