title: SQLite trigger to update Summary Counts
body: <p>Consider the following two (hypothetical) tables</p>
  
  <p>Temperature</p>
  
  <pre><code>* day
  * time
  * lake_name
  * station
  * temperature_f
  </code></pre>
  
  <p>Temperature_summary</p>
  
  <pre><code>* day
  * lake_name
  * station
  * count_readings_over_75f
  * count_readings_below_75f
  </code></pre>
  
  <p>How can I write an <strong>SQLite</strong> Trigger to update the temperature_summary table on insert.  I want to increment the count.</p>
  
  <p>Thank You,
  Jeff</p>