Comprehensive Exercise 2-4-5

Please calculate the number of outpatient registrations and registration fee income for each region based on postal codes during the early September year 90. 請依郵遞區號統計90年9月上旬各地區來院掛號就診人數及掛號費用收入。

Please list the physician codes for doctors who were hospital employees and had outpatient registrations in September year 90. 請列出90年9月有醫院員工掛號就診的醫師代碼。

Please calculate the average copayment and registration fee per department for colleagues who visited the hospital in September year 90. 請算出90年9月每個有同仁來院就醫的部門，平均每個部門貢獻多少部分負擔和掛號費。

Please calculate the number of medical visits for employees 1475, 93, 1002, and 2309 in September year 90. 請統計1475、93、1002、2309這四位員工90年9月份的就醫次數。

Continuing from the previous question, which doctors did these four employees visit in their outpatient sessions? (Please provide three different ways to express the results.) 承前題，這四位員工分別看過哪些醫師的門診。(請以三種不同條件表現方式列出結果)