title: How to find total working hours by each employee from their start date in sql?
body: <p>A company record its employees movement In and Out of office in a table with 3 columns
  <code>(Employee id, Action (In/Out), Created)</code>.</p>
  <p>First entry for each employee is “In”.
  Every “In” is succeeded by an “Out&quot;. No data gaps and, employee can work across days.</p>
  <pre><code>Employee id  Action  Created
  1             In    2019-04-01 12:00:00
  1             Out   2019-04-01 15:00:00
  1             In    2019-04-01 17:00:00
  1             Out   2019-04-01 21:00:00   
  </code></pre>
  <p>Question is to Measure amount of hours spent by each employee inside the office since the day they started (Account for current  shift if she/he is working). Can you help in solving this ?</p>