margin-of-victory.sql

SELECT
	the_geom_webmercator,
	precinct_number,
	cartodb_id,

	democratic_obama_biden,                        -- 1st Candidate
	republican_mccain_palin,                       -- 2nd Cadidate

	CAST ((democratic_obama_biden -                -- change to 1st candidate
               republican_mccain_palin  ) AS float)    -- change to 2nd candidate
        / 
        CAST ((democratic_obama_biden +                -- change to 1st candidate
               republican_mccain_palin  ) AS float)    -- change to 2nd candidate
        * 100  
		
	    AS margin

FROM obama_vs_mccain_2008                              -- TABLE NAME

WHERE 
	precinct_number IS NOT null