I need help with a SQL query to group it by weekly date. Not sure how to go about doing this so that I can get the date to group from Monday - Sunday and give me the sum. Below is my query and example:
SELECT NAME, DATE, REG, OVT, TOTAL
It's a simple query, but I need to be able to group it. See the screenshot example.