title: IIS Log Parser - Need Query to find "total requests taking > x secs" / "Total Requests" grouped by URL
body: <p>I am supporting an application that is having occasional performance issues. The client wants to know how often a page is slow.</p>
  
  <p>i.e. Total times a page took greater than x secs / Total number of requests for the page </p>
  
  <p>I would like to write a single query to fetch the desired data. </p>
  
  <p>Something like this in SQL would probably work but isn't working in IIS Log parser.</p>
  
  <pre><code>select URL, count(case when time &gt; 100  then 1 else null end), count(*)
  from   table1
  group by URL
  </code></pre>