cd into the sql-practice folder. Run npm install to install the dependencies. Execute the file build-db.sql in the terminal to build the database, and populate it with seed data. sqlite3 dev.db ".read ...

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 ...