title: how to get some field of current week data and some of next 7 days data in mysql
body: <p><a href="https://i.stack.imgur.com/bLyAM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bLyAM.png" alt="Sample data" /></a>Hi everyone i have tried to write query so i want result as weekly_outstanding column data in current week and recover column get next 7 days data.<br />
  3 input paramter team_id, week_start_date, week_end_date
  output as expected weekly_outstanding column data based on input paramter and recovery data comes from next 7 days
  for ex- i have select date between 2022-03-28 to 2022-04-03 in input parameter so weekly_outstanding data comes from this week and recovery comes from next week</p>
  <pre><code>SELECT sum(weekly_outstanding) as last_week_os, sum(recovery)  FROM `fleet_driver_dash_weekly` WHERE team_id=1 and (week_start_date='2022-03-28' and week_end_date='2022-04-03'
  </code></pre>