People, including me, often expect the wrong thing from SELECT DISTINCT,
May suggest you do the following:
Create table temp_tb_spots as
Select * from tb_spots where aired_station = '??'
;
select distinct Date from temp_tb_spots group
;
In a different window run
Select Date from temp_tb_spot
I'm not aware of any problems with DISTINCT, though it often seems that how
people expect it to work differs from how it actually works.
It would help if you could provide more details. For example, what do you
mean by "large gaps"? Do you mean there are rows which match the WHERE
condition w
