Find out which patients have not been discharged yet

Reference no: EM13773916

Part A - SQL Queries

Use the hospital database (hosp2010.sql) from the Interact Resources site. Answer the following queries from that database.
You are required to submit:

1. The appropriate SQL statements for each query, which should be copied from your SQL code in MySQL and pasted into your submission file

2. Screenshots of the resultant tables which are to be pasted into your submission file immediately after the SQL code for that query.
Typing or manually drawing the results is NOT acceptable.

Question 1

Find out what actual operations were performed by the surgeon 103. List the surgeon code, the code of the actual operation and the date the operation was performed. Show the operation date by the day of the week, the day of the month, the month and the year (ie: Tuesday, 7 October, 2014). Sort the list in most recent date of operation.

Question 2

Find out which patients have not been discharged yet, listing their last name and the date they were admitted. Show the admission date by the day of the month, month and the full year (ie: 6/12/2001).

Question 3

List all the persons who were admitted to the Flemming Ward prior to 1995. Show the persons first and last name, ward name and the date of their admission. Show the admission date by the day of the month, month and the full year (ie: 6/12/2001).

Question 4

For the patients who have been discharged, show the number of days that they stayed at a ward. Also show the patients ID and last name, ward code and the date of admission. Show the admission date by the day of the week, the day of the month, the month and the year (ie: Tuesday, 7 October, 2014). Sort the list in most recent date of admission.

Question 5

1. List the first name and surname of male patients from NSW or ACT (i.e. the postcode is in the 2000's), who have had an operation and recovered in either the Pasteur or the Fleming ward. Mention them only once if they recovered in the same ward more than once.

2. After executing your query, explain the logic of your SQL statement/s (for example, why/how you joined tables and for what reason, etc.), and do this for each part of this query.

Reference no: EM13773916

Questions Cloud

Obtain the fourier series which represents function : Obtain the fourier series which represents function f(t)=0 -2pi/w

The health status of a country plays : You are currently working as an administrative assistant for a large metropolitan hospital. You have been asked to prepare an article for the hospital newsletter about international health care. The following are the items you have been asked to i..

Expand aggregate demand-money supply : If the central bank wants to expand aggregate demand, it can ________ the money supply, which would ________ the interest rate.

Is there a hate or bias crime law in existence in your state : Is there a hate or bias crime law in existence in your state? If not, select a neighboring state to examine so that you are able to complete the assignment. If you live outside of the United States, pick any state to examine that has these laws

Find out which patients have not been discharged yet : Find out which patients have not been discharged yet, listing their last name and the date they were admitted. Show the admission date by the day of the month, month and the full year (ie: 6/12/2001).

Future business conditions and invest in capital equipment : Suppose firms become very optimistic about future business conditions and invest heavily in new capital equipment. Show the short-run effect of this optimism on the aggregate-demand curve. Which of the following reasons could explain why the aggregat..

Write a reflaction paper on the movie les miserables : Write a reflaction paper on the movie Les Miserables 1998. Reflect on one of 3 issues: Social justice: class, gender, economic, etc.

Cloud computing on traditional it infrastructure : Describe the effect of cloud computing on traditional IT infrastructure.

How much gravitational potential energy did the barbells hav : A championship weight lifter did 1.10 * 10 to the power of 4 J of work on a set of barbells weighing 3680N. How much gravitational potential energy did the barbells have at the maximum height of a lift?

User Account

All Pages