Question: Thank you, here is my question. The database name is Hospital . Tables Doctor DID DName DPhone 1111 James Marks 719-555-1111 1222 Jason Marks 719-555-1111

Thank you, here is my question.

The database name is Hospital.

Tables

Doctor

DID

DName

DPhone

1111

James Marks

719-555-1111

1222

Jason Marks

719-555-1111

1333

Joe James Smith

1444

Jason Marks

650-555-6666

Patient

PID

PName

PState

PAge

3111

Mary Marks

CO

54

3333

Matt Marks

CO

28

3444

Ming Lee

TX

19

3555

Mike Chong

AZ

43

Visit

VID

Date

DID

PID

4001

03-21-2013

1111

3111

4002

04-04-2013

1111

3333

4011

12-21-2014

1111

3111

4014

03-02-2015

1222

3111

4035

07-22-2016

1444

3555

Treatment

TID

TName

Cost

VID

5001

Flu Shot

10.00

4001

5002

Annual Checkup

55.00

4001

5003

EKG

110.00

4001

5011

Flu Shot

10.00

4014

5059

X-ray

78.00

4035

1. WITHOUT USING JOIN, list the patient's ID and name for patient(s) who have ever had a flu shot. Exclude duplicated results.

2. For each patient, list patient's ID and the total treatment cost. Since some visits do NOT involve any expenses, ignore patients whose total treatment cost is zero.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Please help. Thanks! The database name is Hospital . Tables Doctor DID DName DPhone 1111 James Marks 719-555-1111 1222 Jason Marks 719-555-1111 1333 Joe James Smith 1444 Jason Marks 650-555-6666...

Q:

The database name is Hospital . Tables Doctor DID DName DPhone 1111 James Marks 719-555-1111 1222 Jason Marks 719-555-1111 1333 Joe James Smith 1444 Jason Marks 650-555-6666 Patient PID PName PState...

Q:

Use the 4 tables in the attachment as reference, write ONE SQL script to handle the following three functions: create, update, and delete. Create Create a database named IS3400. Then create 4 tables...

Q:

According to the annual report record of Royal bank of Scotland(showed via pictures just below the questions) and answer the following questions: 1.How does the bank address ethical concerns? 2.Where...

Q:

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

Q:

Scenario/Summary Hopefully you will find this week's iLab activity fun and useful. We'll be exploring the world of statistics from a business perspective this week, allowing you to practice your...

Q:

4. Consider a Chatbot that generates a Markov chain Xo, X1, X2, ... with transi- tion probabilities thank thank Pthank, you Pthank, so thank, much Pyou, thank Pyou, you Pyou, so Pyou, much P = Pso,...

Q:

please help me develop a strong and convincing character letter for Jennifer based off of the information given and the texts as she was very accommodating with me when I had my back injury and...

Q:

2019 - RBS - Annual Results 2019 RBS - Annual Results 2019 With that, I'll hand over to Alison. Introduction Good morning, ladies and gentlemen. Today's conference call will be hosted by Chairman...

Q:

Feedback Form 1 "WHERE DREAMS COME HOME" Your Ho e Real Estate WWW. YOURHOMEREALESTATE.COM Customer Satisfaction Survey Hello! We need your help! Please fill out this brief survey regarding your...

Q:

Calculate your individual ecological footprint online. (Search for "ecological footprint.") Are you living sustainably? Suggest two things that you could do to lower your ecological footprint.

Q:

Altugs Coffee Shop decides to install an automatic coffee vending machine outside one of its stores to reduce the number of people standing in line inside. Mehmet Altug charges $ 3.50 per cup....

Q:

8 . Which one of the following is indicative of a totally efficient stock market?extraordinary returns earned on a routine basisb. positive net present values over the long - termzero net present...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

3. Try to find information on how projects are managed at XYZ Multimedia. Inquire what project management methodologies and tools are used at this company. If possible, show you are familiar with...

Q:

1. Have you ever worked on an IT project? What did you do? Did you work with any project management tools such as Microsoft Project?

Q:

4. What is your proficiency level with Microsoft Office tools and with Microsoft Project and SharePoint?