Question: For the below tables, please write SQL queries: Patient_Diagnosis Field Name Description Data Type Notes Patient_ID Patient Identifier INTEGER Diagnosis_Date Date of Diagnosis DATE YYYY-MM-DD

For the below tables, please write SQL queries:

Patient_Diagnosis
Field Name		Description		Data Type		Notes
Patient_ID		Patient Identifier		INTEGER
Diagnosis_Date		Date of Diagnosis		DATE		YYYY-MM-DD
Diagnosis_Code		Diagnosis Code		TEXT
Diagnosis		Internal Description		TEXT
Patient_Treatment
Field Name	Description		Data Type		Notes
Patient_ID	Patient Identifier		INTEGER
Treatment_Date	Date of Treament		DATE		YYYY-MM-DD
Drug_Code	Internal Drug Identifier		INTEGER

For the above tables, I am unable to arrive at a solution using SQL. Please help me with these SQL questions.

How long after being diagnosed does it take for a patient to start treatment? Do any patients start treatment before being diagnosed?
After being treated with a first line of treatment (a drug or combination of drugs), what proportion of all cancer patients go on to be treated with a second line of treatment?
How does each drug used at the clinic compare in terms of its duration of therapy?

For the below tables, please write SQL queries: Patient_Diagnosis Field Name

Description Data Type Notes Patient_ID Patient Identifier INTEGER Diagnosis_Date Date of Diagnosis

The above is the sample dataset I was given.

Patient_Diagnosis.csv B A Patient_ID 2038 2120 2175 2010-01-21 2010-01-09 Diagnosis_Code Diagnosis 174.9 Breast Cancer 174.1 Breast Cancer 2010-02-17 174.7 Breast Cancer 2407 2010-06-13 174.9 Breast Cancer 174.9 Breast Cancer 2425 2010-12-15 2462 2011-01-07 174.9 Breast Cancer 2634 2011-02-19 153.9 Colon Cancer 2735 2011-04-18 174.9 Breast Cancer 2763 2011-04-19 174.1 Breast Cancer 2770 2011-04-16 3095 2011-07-10 2011-09-07 153.9 Colon Cancer 153.3 Colon Cancer 153.5 Colon Cancer 3449 3757 2011-10-11 153.4 Colon Cancer 2011-10-11 174.1 Breast Cancer 3757 3948 2011-12-18 174.6 Breast Cancer Patient_Treatment.csv A Patient_ID Treatment_Date Drug_Code 2010-02-14 201 2038 2038 2010-02-21 2038 2010-02-26 2038 2010-03-07 2010-03-14 2038 2038 2038 2038 2038 2010-03-21 2010-03-26 2010-04-04 2010-04-11 2038 2010-04-18 2010-04-25 2038 2038 2010-05-02 2038 201 2010-05-09 2010-05-16 2010-02-20 2010-02-27 2010-03-01 2010-03-08 2010-03-15 2010-03-22 2010-03-29 2010-04-05 2010-04-12 2010-04-19 2010-04-26 2038 2120 2120 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2175 2407 2407 2010-05-03 2010-05-10 2010-05-17 2010-05-24 2010-05-31 2010-06-07 2010-06-14 2010-06-21 2010-06-28 2010-07-05 2010-07-28 2010-08-04

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!

For the below tables, please write SQL query: Patient_Diagnosis Field Name Description Data Type Notes Patient_ID Patient Identifier INTEGER Diagnosis_Date Date of Diagnosis DATE YYYY-MM-DD...

Create a Data Dictionary Entry for a new Data Element Operative Procedures According to Table 1.1. on the next page the Admission Summary sheet at Valley View General is already capturing data on...

Please read carefully the description of the case study that follows. SUMMARY ELK County Maine has been awarded a federal grant to build a modest pediatric medical center. The grant also paid for the...

SUMMARY ELK County Maine has been awarded a federal grant to build a modest pediatric medical center. The grant also paid for the medical education of a pediatrician that will practice at the medical...

CIS-336: Lab 3: Building the Physical Model LAB OVERVIEW Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model...

Below are the specifications contained in the Data and Information Requirements section of the PMC Functional Requirements Report. Family Information The PMC medical system needs to track information...

A Donor with the following attributes: Donor ID, Name, Date of birth, Gender, Address. A Blood unit donated by a donor. The blood unit attributes are blood code (unique), blood amount, donate date,...

Overview Joining tables can be confusing at first. To complicate matters there are several methods that can be used. Oracle had its traditional method and then the ANSI organization added its various...

Please help me Answer these questions for FINANCE the instructions are posted on top ASAP Please follow the following additional instructions when completing the assignment: Assume that cash flows...

M/s. TB is a partnership firm with the partners A, B and C sharing profits and losses in the ratio of 3: 2:5. The balance sheet of the firm as on 30th June, 2020 was as under : Liabilities Balance...

question 2 Ahmed, Babu and Chatu are partners sharing profit and losses in the ratio 3:1:1 after interest on capital at 10% and salaries to Babu and Chatu of sh 300,000 each. Their trial balance for...

Enabled: Exam 2 _ MC ( i ) When saving for future expenditures, we can add the of contributions ove Multiple Choice 2 . 4 5 present value time value to money payment future value

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Understanding Group Leadership Culture and Group Leadership

Have you ever misunderstood another member of a group you were involved in because of cultural differences? If so, how did you and the other person deal with the misunderstanding?

4. The telephone game, passing a message from person to person, is fun simply because of the inevitable message distortion that gets revealed at the end. Can you think of a time when a message was...