title: "Opening Shows" on Postgres
body: <p>I have a shows table and a performances table.</p>
  
  <p>I am trying to find "shows about to open" by asking for "shows whose first performances occurs within the next week".</p>
  
  <p>Here are the pertinent data fields:</p>
  
  <p>SHOWS<br/>
  id<br/>
  name (varchar)<br/>
  ...</p>
  
  <p>PERFORMANCES<br/>
  id<br/>
  show_id (int/fk)<br/>
  date_time (datetime)<br/>
  ...</p>
  
  <p>I am thinking the group by clause would be needed here, but I haven't been able to figure it out.</p>
  
  <p>Any help would be amazing.</p>
  
  <p>thanks!</p>