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

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

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 the full answer