This repository provides mobile network operators with code and guidelines to produce aggregates from their raw CDR data (Call Detail Records), originally developed in the context of the COVID-19 ...

SQL-Database-Applications-Portfolio SQL projects for concert, parking, & flight tracking databases. Features normalized schemas, stored procedures, DML, & advanced queries (joins, aggregates).

edit: I didn't read the whole question. :facepalm: But basically, grouping by the day of week in place of date should get you where you want to go. Start with the query you posted above, then use that ...