Exercise 1-3

To find the average and total registration fees for each Monday in September, year 90 (on 9/3, 9/10, 9/17, and 9/24). 請以一完整SQL寫出找出90年9月份每週一掛號費的平均與總和之敘述。(9/3, 9/10, 9/17, 9/24)

Evaluate responses using AI:

OFF

To find the maximum and minimum copayment amounts for mid-September registration data in year 90 and calculate the difference. 請以一完整SQL寫出找出90年9月中旬掛號資料中的最大部份負擔金額與最少部份負擔金額，並計算其差。

Evaluate responses using AI:

OFF

To find the number of registrations and average registration fee for the early September and later September in year 90. 請以一完整SQL找出計算90年9月上旬和下旬門診掛號資料的掛號人次及平均掛號費用。

Evaluate responses using AI:

OFF

To find the total copayment amount and average copayment per person for September, year 90. 請以一完整SQL找出90年9月份門診掛號資料中的部分負擔金額總和及平均每人次的部分負擔金額。

Evaluate responses using AI:

OFF

To calculate the average number of visits per patient in the early September, year 90. 算出90年9月上旬平均每個病人到院幾次。

Evaluate responses using AI:

OFF

Please use SUM function and COUNT function to calculate the average registration fee income per shift in the fourth quarter of year 90. 請使用sum及count函數計算出90年第四季的所有時段，平均一個時段有多少掛號費收入。

Evaluate responses using AI:

OFF