The "Peace" attribute is backwards?


#1

Is the code for the “Peace” attribute backwards? Libya and Iraq are rated as “good,” and Canada, Norway, and Sweden are rated “bad” on the “Peace” attribute?!? Libya has warring factions instead of a government. Sweden awards the Nobel Peace Prize. Kurdistan doesn’t even have a “Peace” rating. Shouldn’t the “Peace” attribute rate the chances that artillery will shell your hotel, or an army will invade the beach? I started adding some corrective ratings, but really the code needs to swap “bad” and “good”, and remove all recent ratings (which will then be in the wrong direction). Perhaps something like this SQL…
UPDATE
peace_table p
SET
p.score = 5 - p.score;


#2

#3

#4