CS580_Assign2_DeepakMuthaiyan

docx

School

Boston University *

*We aren’t endorsed by this school

Course

580

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

6

Uploaded by SargentMask24623

Report
CS 580 Assignment 2 Name: Deepak Muthaiyan BU ID : U12253188 A) SELECT (sum(CASE gender WHEN 'Male' then 1 else 0 end)/sum(1))*100 as malePercent FROM `patient_core` The male percent is 48% B) SELECT (sum(CASE race WHEN 'African American' then 1 else 0 end)/sum(1))*100 as AfricanAmercianPercent FROM `patient_core` The AmericanAfricanPercent is 15%
C) SELECT COUNT(primary_diagnosis_description) FROM `admission_diagnosis_core` WHERE admission_diagnosis_core.primary_diagnosis_description like '%type %1%diabetes%' Admissions for Type 1 Diabetes is 580
D) SELECT COUNT(DISTINCT patient_id) FROM `admission_diagnosis_core` WHERE primary_diagnosis_code LIKE '%E10%' Patients admitted due to Type 1 Diabetes is 567 E) We are taking the 3 patients. The ids are : 009ED699-7264-4BC6-80BC-6214321FA867 016A4267-593F-4520-968E-FD8F97FC4E42 02B867CE-8212-4E86-83F3-80D20AAB8FBA For Patient id 02B867CE-8212-4E86-83F3-80D20AAB8FBA we can see gender is female, Date of birth is 1937-04-23, Race is white, Martial status is married, Her language is English, population_percentage_below_poverty is 15.29 and she was admitted 5 times in the hospital SELECT * FROM `patient_core` WHERE id='02B867CE-8212-4E86-83F3- 80D20AAB8FBA'
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
SELECT * FROM `virtual_patient_repository`.`admission_core` WHERE `patient_id` = '02B867CE-8212-4E86-83F3-80D20AAB8FBA' ORDER BY `start_date` DESC ii) For Patient id 016A4267-593F-4520-968E-FD8F97FC4E42 we can see gender is male, Date of birth is 1926-03-08, Race is Asian, Martial status is Single, His language is English, population_percentage_below_poverty is 11.96 and he was admitted 4 times in the hospital SELECT * FROM `patient_core` WHERE id='016A4267-593F-4520-968E- FD8F97FC4E42' SELECT * FROM `virtual_patient_repository`.`admission_core` WHERE `patient_id` = '016A4267-593F-4520-968E-FD8F97FC4E42' ORDER BY `start_date` DESC
iii) For Patient id 009ED699-7264-4BC6-80BC-6214321FA867 we can see gender is female, Date of birth is 1929-02-03, Race is AfricanAmerican, Martial status is Single, Her language is English, population_percentage_below_poverty is 13.56 and she was admitted 3 times in the hospital SELECT * FROM `patient_core` WHERE id='009ED699-7264-4BC6- 80BC-6214321FA867' SELECT * FROM `virtual_patient_repository`.`admission_core` WHERE `patient_id` = '009ED699-7264-4BC6-80BC-6214321FA867' ORDER BY `start_date` DESC
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

23F-A4 (1).docx
lab06.py
project04.py
project03.py
LP2 QUIZ.docx
CSN105_SubnettingNetwork.docx
Stats Project2.pdf
7.1 Cryptography.pdf
Homework--2.pdf
ASSIGNMENT 3 CIT210 OP. SYS. MANAGE FALL 2023.docx
hw10.pdf
hw08.pdf
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SEE MORE TEXTBOOKS