Final-[期末考]

Final-[期末考]

University

10 Qs

quiz-placeholder

Similar activities

Pretest 2

Pretest 2

University

10 Qs

SOAL : Pengenalan Basis Data

SOAL : Pengenalan Basis Data

University

10 Qs

Modelos de Bases de Datos

Modelos de Bases de Datos

University

10 Qs

Avaliação de Laboratório de Software

Avaliação de Laboratório de Software

University

10 Qs

情報I  第一学期 Scratch 複習

情報I 第一学期 Scratch 複習

9th Grade - University

15 Qs

IT Quiz

IT Quiz

University

15 Qs

土木工程施工技術6.

土木工程施工技術6.

University

10 Qs

Архітектура ПЗ

Архітектура ПЗ

University

11 Qs

Final-[期末考]

Final-[期末考]

Assessment

Quiz

Computers

University

Practice Problem

Easy

Created by

Chun-Jung Lin

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

OPEN ENDED QUESTION

30 sec • Ungraded

班級 Name

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers