无法解析查询，融合表API高级可视化示例代码

Question

从fusion tables API高级可视化示例代码中给出的示例，我设法想出了一个地图和图例。但是，柱状图没有显示。“无法解析查询”是正在显示的错误。可能的问题是什么？

这是我的柱状图代码。

      function drawVisualization(County) {
    google.visualization.drawChart({
      containerId: "visualization",
      dataSourceUrl: "http://www.google.com/fusiontables/gvizdata?tq=",
      query: "SELECT Environment,'BoysPupils','GirlsPupils','FemaleTeachers','MaleTeachers','BoardingPupils' " +
          "FROM 1eC4sIAgVXfFj01mOM2cDiyW2nly7TcFeIXj1G3s WHERE County = '" + County + "'",
      chartType: "ColumnChart",
      options: {
        title: County,
        height: 400,
        width: 400
      }
    });
  }

Answer 1

您使用了两个错误的列名：'BoysPupils','GirlsPupils'

它必须是'BoyPupils','GirlPupils'