title: How To get the Last 15 minutes values(sessions) for each row in the table in sql select with SUM
body: <p><img src="https://i.stack.imgur.com/HxHuo.jpg" alt="Log Analyzer table Table for reference"></p>
  
  <blockquote>
    <p>I want to get a table of </p>
    
    <p>1> requestTime  2> NumberOfSessionsInLast15minutes</p>
    
    <p>How to write the query to get a table where the requestTime column
    will be same and the NumberOfSessions column will be sum of sessions
    in last 15 minutes </p>
    
    <p>EXAMPLE: </p>
    
    <p>The number of sessions for this one 2012-06-06 00:12:00.0000  should
    be sum of sessions betwen 2012-06-06 00:12:00.0000 and (2012-06-06
    00:12:00.0000) - 15 minutes .</p>
  </blockquote>