SELECT all_120210.total AS "120210", all_120217.total AS "120217", all_120210.std, area_code.city, ( 100 - ( all_120217.total / all_120210.total ) *100 ) AS "%diff"
FROM all_120217
LEFT JOIN all_120210 ON all_120217.std = all_120210.std
LEFT JOIN area_code ON all_120217.std = area_code.code
ORDER BY `%diff` DESC
