班級 Name
![Final-[期末考]](https://cf.quizizz.com/image/assessment-square.png?w=200&h=200)
Final-[期末考]

Quiz
•
Computers
•
University
•
Easy
Chun-Jung Lin
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
OPEN ENDED QUESTION
30 sec • Ungraded
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
30 sec • Ungraded
學號 Student Number
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
30 sec • Ungraded
姓名 Name
Evaluate responses using AI:
OFF
4.
OPEN ENDED QUESTION
30 sec • 20 pts
請寫出一SQL,可以統計出醫院女性同仁,身份證為L和K開頭且為處女座 Virgo (08/23 - 09/22)並曾在91年4月有掛號的人數。
Please write an SQL query that can count the number of female colleagues in a hospital whose ID numbers start with 'L' or 'K', are Virgos (08/23 - 09/22), and have registered in April of the year 91.
Evaluate responses using AI:
OFF
5.
OPEN ENDED QUESTION
30 sec • 20 pts
請寫出一完整SQL,使用subquery 的all找出90年11月上旬,以預約掛號就診、部分負擔費為零,並亦曾在當月下旬以 現場 或 預約 方式就診之病患病歷號。(現場 = ‘1’、預約 = ‘2’)
Please write an SQL query that using Subquery (ALL) to Find Medical Record Numbers of Patients Who Had Zero copayment Fees and Visited Either On-site or by Appointment in the First Ten Days of November year 90.
Evaluate responses using AI:
OFF
6.
OPEN ENDED QUESTION
30 sec • 20 pts
請寫出可以算出91年三月每個有病患掛號的醫師,每個醫師平均可以分配多少部分負擔和掛號費(兩者之和)金額的SQL。(例如:若部分負擔和掛號費的總合為10000元,有4個醫生有病患掛號,則平均每個科可分配到2500元。
Please write an SQL query that can calculate Average Allocation of copayment and Registration Fee for Each Doctor in March year 91.
Evaluate responses using AI:
OFF
7.
OPEN ENDED QUESTION
30 sec • 20 pts
請以一完整SQL找出90年11月份每天下午時段的掛號現金收入,單日出現最高 的掛號現金收入及日期。
Please write an SQL query that can find the Highest Daily Cash Registration Income in the Afternoon Shifts of November year 90.
Evaluate responses using AI:
OFF
Create a free account and access millions of resources
Similar Resources on Quizizz
8 questions
2024-25 年中一級電腦科 下學期課本練習 2

Quiz
•
7th Grade - University
10 questions
Python Language 2

Quiz
•
University
10 questions
Final-<期末考>

Quiz
•
University
10 questions
Concept of Computer Network

Quiz
•
University
6 questions
Chapter5_review

Quiz
•
University
10 questions
Arduino-5

Quiz
•
University
11 questions
C++程式

Quiz
•
11th Grade - University
10 questions
SQL Queries

Quiz
•
University
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade