Druid Group by Day of Week and Hour of Day

I am trying to find how to group by day of week, and also hour of day in Druid. I am relying on Druid documentation here: https://druid.apache.org/docs/latest/querying/sql.html, and all the following functions are from this page.


This is a companion discussion topic for the original entry at https://stackoverflow.com/questions/72036523/druid-group-by-day-of-week-and-hour-of-day