SELECT *,  ((State = 'CA') + (City = "Chico")) AS score  FROM `Address`
       HAVING score > 0
       ORDER BY score DESC