Datepart day of week date July 8, 2019 16 32 64 128 Select datepart(day of week date) average(sales) from sales group by 1
