title: SQL Alchemy selecting data
body: <p>I'm trying to do a group by + count with a weather stations table to answer the following questions:</p>
  
  <h1>What are the most active stations? (i.e. what stations have the most rows)?</h1>
  
  <h1>List the stations and the counts in descending order</h1>
  
  <p>The table consists of the following values:
  id INTEGER
  station TEXT
  date TEXT
  prcp FLOAT
  tobs FLOAT</p>
  
  <p>This is my current formulation of the select statement:</p>
  
  <pre><code>sel = [Measurement.station, func.count(Measurement.id)]
  count = session.query(*sel).all()
  
  count
  </code></pre>