ID value Percentage
AA A1 100
AA A2 80
AA A3 80
AA A4 90
AA B1 100
AA B2 55
AA B3 100
AA B4 100
BB A1 100
BB A2 50
BB A3 50
BB A4 90
BB B1 20
BB B2 90
BB B3 90
BB B4 100
I have to output my data set to the following table.
ID A B
The following rules apply
For each ID I have to check the value that starts with A
I have to check percentages of each value that starts with A. If all percentages are >75 and < 100 then I have to write "W/W" in the output table under A.
If one of the percentages is 50 my output will be "W/<the value whose percentage was 50" for A.
If two or the percentages is 50 my output will be "the value whose percentage was 50 / the other value whose percentage was 50".
if one percentage 0 my output will be "the value whose percentage was 0 / the value whose percentage was 0"
All other cases output will be "F/F"
Master of Science in Information Technology, atleast 8 years of web development experience (PHP, MySQL, jQuery). Professional designer will create responsive design using latest technologies (bootstrap, html5, css3). Daha Fazla
Bu iş için 6 freelancer ortalamada $60 teklif veriyor
Hello sir, I'm interested and ready to work on it. Thanks.
I have good experience in MySQL and sql i can help you to get this query done once i finished then pay me no down payment needed once finished then i can get the money from you . I am ready to start the work immediate Daha Fazla