Question: Using oracle SQL syntax: A. How many percent (%) of patients are women? B. How many percent (%) of patients are Asians? Patient_ID 1

Using oracle SQL syntax: A. How many percent (%) of patients are women? B. How many percent (%) of patients

Using oracle SQL syntax: A. How many percent (%) of patients are women? B. How many percent (%) of patients are Asians? Patient_ID 1 2345 6 7 8 00 9 10 11 12 GENDER Female female Female Female Female Male Male Male Male Male Male Male DIAGNOSIS_ID ED-10.1 MAC 10.8 FDA 20.1 EMC-340 DDA-507 HAM-230 DDU-553 MAC-10 EDU-321 HHP-112 OPM-21 ABU-20 AGE RACE 30 HISPANIC 40 BLACK 80 ASIAN 98 ASIAN 50 BLACK 87 WHITE 34 WHITE 78 BLACK 65 ASIAN 54 HISPANIC 29 HISPANIC 40 WHITE

Step by Step Solution

3.36 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

A How many percent of patients are women Using oracle SQL syntax SQL SELECT ROUNDCOUNTCASE WHEN GENDER Female THEN 1 END COUNT 100 2 AS percentfemale ... View full answer

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 Programming Questions!