PostgreSQL data source using between clause for date ranges

Hello I have a local grafana setup version 8.4 along with a local postgresql setup and created and sucesfully connected to the data source. I have some example test data in said database and wanted to create a dashboard. I need to display a graph with the difference between 2 date rows stored in that database. I have a query which uses between parameter to get that. I have a createdAt and updatedAt column respectively and would need a graph/time series where X is a day of the week and Y is how many rows in the DB where TRUE for the between. Something like “day_variable between column_a and column_b”

I have followed this guide : PostgreSQL | Grafana documentation