Devam Ediyor

Writing SQL query - repost

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"

Beceriler: MySQL, SQL

Daha fazlasını görün: writing rules, rules writing, sql query, query table, b3, b2, 2013 query, mysql output table, output table, check sql, sql write, sql write query, dnn query sql, php html query sql, sql table writing, writing sql mysql, parent child query sql, query sql 2005 csv, write mysql query

İşveren Hakkında:
( 52 değerlendirme ) San Diego, United States

Proje NO: #4454170

Seçilen:

pauljacionis

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

1 gün içinde 33$ USD
(1 Değerlendirme)
5.1

6 freelancer bu iş için ortalamada 60$ teklif veriyor

dobreiiita

I can complete this project !! Easily !

1 gün içinde 54$ USD
(21 Değerlendirme)
4.4
Kilr0y

Hello. Please see PM for details.

1 gün içinde 66$ USD
(7 Değerlendirme)
4.1
chinbochen

Hello sir, I'm interested and ready to work on it. Thanks.

in 3 gün içinde105$ USD
(0 Değerlendirme)
0.0
xuhaijiao

hi, sir, i can do that in good quality.

1 gün içinde 55$ USD
(0 Değerlendirme)
0.0
kumba007

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

1 gün içinde 45$ USD
(0 Değerlendirme)
0.0