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.


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: writing rules, w for writing, rules of writing, rules for writing, write query, SQL Query, query table, mysql to sql, B3, b2, 2013 query, mysql output table, output table, check sql, writing apply job sql server asp net, sql write, sql write query, sql query check child table, dnn query sql, php html query sql, sql table writing, uusing data adaptor aspnet query sql server database, parent child query sql server, writing sql mysql, net query sql mobile table example

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

Proje NO: #4454170



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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)

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


I can complete this project !! Easily !

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)

Hello. Please see PM for details.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde105%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)