selecting certain day of week from range of dates ?
I have a table with a count of customers for about a year, but I only want to select Wednesday and Thursday of
each week, starting at the beginning of dates. Table is simple and has two columns. Each row is Distinct to a Date,
there are no Date duplicates, it's counted for each day of the year.
column 1: count of customers, count(customer_id)
column 2: Date
Need some help in best way of doing this.
Not even sure if this is possible to select a date using the day name ?
Basically I want to select each Wednesday and Thursday from each week and compare the counts week over week, over
week for all week to see if the counts are going up or down, to get trends, thanks!