Browse 531 attributed reviews, viewable separately for our classroom and online training

### Added by najilevi on 26 Jul 2018 at 09:08

Hi,

I tried to solve exercise B with the WAR and the DEATH but haven't succeeded207 yet.  Can someone can help me and write the correct answer?

This is what I wrote:

select *
from tblEvent
where CategoryID = 5 or CategoryID = 6 and (EventDetails not like ('%war%death%')

Thanks

if i have array of numbers

10, 9.8, 10.1, 9.5, 10.8, 9.7

I would like to arrange this array by nearest to 10.

To compare this array to 10. I am going to subtract array values from 10:

(10-10), (10 - 9.8), (10-10.1), (10-9.5), (10-10.8), (10-9.7)

0, 0.2, -0.1, 0.5, -0.8, 0.3

To compare numbers i have to consider both postives and negatives, so i am going to use absolute values

0, 0.2, 0.1, 0.5, 0.8, 0.3

Now let's arrange these numbers nearest to 10:

0, 0.1, 0.2, 0.3, 0.5, 0.8

Now write down with corresponding numbers:

10, 10.1, 9.8, 9.7, 9.5, 10.8

So to summarize, i arranged numbers by using ABS(MyNumbers - 10)