Final-(期末考)

班級 Class

學號 Student Number

姓名 Name

請寫出一完整SQL，可以統計醫院男性同仁血型是O型和A型且為雙魚座 Pisces (02/19 - 03/20)，且在91年6月有掛號的人數。

Please write a complete SQL query to count the number of male colleagues in a hospital with blood types O and A, who are Pisces (02/19 - 03/20), and registered in June of the year 91.

請寫出一完整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 90th year, and also registered on-site or by appointment in the 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 registration methods used in April of the year 91 and allocate the total amount of copayments and registration fees (sum of both) for each method. (e.g., if the total amount of copayments and registration fees is 10,000 and 4 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 yera 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)