I have this current query:
which results in:
I want to take all of those "status_changes" and break them out uniquely by day, so that I can see the status changes by day, and them sum them up at the end. It would look like this:
Is this possible? My main goal is to make it so line 12 "count(distinct driver_id) as status_changes" is unique by day, instead of throughout the entire "spot_Check_begin" to "spot_check_end" timeframe.
Perhaps I am missing the bigger picture of a possible different query?