title: How to group by(mysql) a particular timestamp range to show data in graphs?
body: <p>I have to use a table data that I have to use in graphs in a format shown in picture below.
  <a href="https://i.stack.imgur.com/o9est.png" rel="nofollow noreferrer">Demo graph</a></p>
  <p>This is my data table below
  <a href="https://i.stack.imgur.com/8SxgC.png" rel="nofollow noreferrer">sql data</a></p>
  <p>My goal is to use filters on that, in which timestamp range will be same as shown in graphs, and I have to filter it based on system.</p>
  <p>For example, on 28 January 2022, system &quot;3IN1&quot; got down 3 three, and on 29th January ,it got down 0 time and so on till a week. Then similarly for all the systems mentioned in image below. How to achieve it with a sql query and group by.</p>