title: Google Fusion Tables SQL Query ORDER BY and GROUP BY in same query doesn't work
body: <p>I'm writing a mobile web page using Google Fusion Tables for my data and I need to use both <code>ORDER BY</code> (lat and long) as well as <code>GROUP BY</code> (in place of <code>DISTINCT</code> - which GFT doesn't support).</p>
  
  <p>But, it seems the two do not play well together.  If I use <code>GROUP BY</code>, the statement seems to simply ignore the <code>ORDER BY</code>.</p>
  
  <p>SQL statement:</p>
  
  <pre><code>SELECT Count(), Facility_Name FROM 2206340 GROUP BY Facility_Name 
  ORDER BY ST_DISTANCE(Lat, LATLNG(" + lat + "," + lng + "))LIMIT 10
  </code></pre>
  
  <p>Has anyone else run into this scenario?</p>