$query = db_select("node","n");
$query->fields("n",array("nid","likes" => "SUM(likes)"));

1054 Unknown column 'n.SUMlikes' in 'field list'

$query = db_select('node','n')
  ->fields('n',array('nid'));
$query->addExpression('SUM(likes)','likes');