허접한 방법인데 제가 2000이라..
한 사람씩 조회한다면 아래 방법으로 해도 상관은 없을것 같은데 
많은 사람를 한꺼번에 보여 주는거라면 미리 달력 테이블을 만들어 놓고 
그 테이블을 가지고 조인걸어 하시는게 좋을듯합니다.  
 

create table t_yy
( yyyy char(4)
)
create table t_mm
( mm char(2)
)
create table t_dd
( dd char(2)
)
insert into t_yy values('1900')
insert into t_yy values('1901')
insert into t_yy values('1902')
insert into t_yy values('1903')
insert into t_yy values('1904')
insert into t_yy values('1905')
insert into t_yy values('1906')
insert into t_yy values('1907')
insert into t_yy values('1908')
insert into t_yy values('1909')
insert into t_yy values('1910')
insert into t_yy values('1911')
insert into t_yy values('1912')
insert into t_yy values('1913')
insert into t_yy values('1914')
insert into t_yy values('1915')
insert into t_yy values('1916')
insert into t_yy values('1917')
insert into t_yy values('1918')
insert into t_yy values('1919')
insert into t_yy values('1920')
insert into t_yy values('1921')
insert into t_yy values('1922')
insert into t_yy values('1923')
insert into t_yy values('1924')
insert into t_yy values('1925')
insert into t_yy values('1926')
insert into t_yy values('1927')
insert into t_yy values('1928')
insert into t_yy values('1929')
insert into t_yy values('1930')
insert into t_yy values('1931')
insert into t_yy values('1932')
insert into t_yy values('1933')
insert into t_yy values('1934')
insert into t_yy values('1935')
insert into t_yy values('1936')
insert into t_yy values('1937')
insert into t_yy values('1938')
insert into t_yy values('1939')
insert into t_yy values('1940')
insert into t_yy values('1941')
insert into t_yy values('1942')
insert into t_yy values('1943')
insert into t_yy values('1944')
insert into t_yy values('1945')
insert into t_yy values('1946')
insert into t_yy values('1947')
insert into t_yy values('1948')
insert into t_yy values('1949')
insert into t_yy values('1950')
insert into t_yy values('1951')
insert into t_yy values('1952')
insert into t_yy values('1953')
insert into t_yy values('1954')
insert into t_yy values('1955')
insert into t_yy values('1956')
insert into t_yy values('1957')
insert into t_yy values('1958')
insert into t_yy values('1959')
insert into t_yy values('1960')
insert into t_yy values('1961')
insert into t_yy values('1962')
insert into t_yy values('1963')
insert into t_yy values('1964')
insert into t_yy values('1965')
insert into t_yy values('1966')
insert into t_yy values('1967')
insert into t_yy values('1968')
insert into t_yy values('1969')
insert into t_yy values('1970')
insert into t_yy values('1971')
insert into t_yy values('1972')
insert into t_yy values('1973')
insert into t_yy values('1974')
insert into t_yy values('1975')
insert into t_yy values('1976')
insert into t_yy values('1977')
insert into t_yy values('1978')
insert into t_yy values('1979')
insert into t_yy values('1980')
insert into t_yy values('1981')
insert into t_yy values('1982')
insert into t_yy values('1983')
insert into t_yy values('1984')
insert into t_yy values('1985')
insert into t_yy values('1986')
insert into t_yy values('1987')
insert into t_yy values('1988')
insert into t_yy values('1989')
insert into t_yy values('1990')
insert into t_yy values('1991')
insert into t_yy values('1992')
insert into t_yy values('1993')
insert into t_yy values('1994')
insert into t_yy values('1995')
insert into t_yy values('1996')
insert into t_yy values('1997')
insert into t_yy values('1998')
insert into t_yy values('1999')
insert into t_yy values('2000')
insert into t_yy values('2001')
insert into t_yy values('2002')
insert into t_yy values('2003')
insert into t_yy values('2004')
insert into t_yy values('2005')
insert into t_yy values('2006')
insert into t_yy values('2007')
insert into t_yy values('2008')
insert into t_yy values('2009')
insert into t_yy values('2010')
insert into t_yy values('2011')
insert into t_yy values('2012')
insert into t_yy values('2013')
insert into t_yy values('2014')
insert into t_yy values('2015')
insert into t_yy values('2016')
insert into t_yy values('2017')
insert into t_yy values('2018')
insert into t_yy values('2019')
insert into t_yy values('2020')
insert into t_yy values('2021')
insert into t_yy values('2022')
insert into t_yy values('2023')
insert into t_yy values('2024')
insert into t_yy values('2025')
insert into t_yy values('2026')
insert into t_yy values('2027')
insert into t_yy values('2028')
insert into t_yy values('2029')
insert into t_yy values('2030')
insert into t_yy values('2031')
insert into t_yy values('2032')
insert into t_yy values('2033')
insert into t_yy values('2034')
insert into t_yy values('2035')
insert into t_yy values('2036')
insert into t_yy values('2037')
insert into t_yy values('2038')
insert into t_yy values('2039')
insert into t_yy values('2040')
insert into t_yy values('2041')
insert into t_yy values('2042')
insert into t_yy values('2043')
insert into t_yy values('2044')
insert into t_yy values('2045')
insert into t_yy values('2046')
insert into t_yy values('2047')
insert into t_yy values('2048')
insert into t_yy values('2049')

insert into t_mm values ('01')
insert into t_mm values ('02')
insert into t_mm values ('03')
insert into t_mm values ('04')
insert into t_mm values ('05')
insert into t_mm values ('06')
insert into t_mm values ('07')
insert into t_mm values ('08')
insert into t_mm values ('09')
insert into t_mm values ('10')
insert into t_mm values ('11')
insert into t_mm values ('12') 

insert into t_dd values ('01')
insert into t_dd values ('02')
insert into t_dd values ('03')
insert into t_dd values ('04')
insert into t_dd values ('05')
insert into t_dd values ('06')
insert into t_dd values ('07')
insert into t_dd values ('08')
insert into t_dd values ('09')
insert into t_dd values ('10')
insert into t_dd values ('11')
insert into t_dd values ('12')
insert into t_dd values ('13')
insert into t_dd values ('14')
insert into t_dd values ('15')
insert into t_dd values ('16')
insert into t_dd values ('17')
insert into t_dd values ('18')
insert into t_dd values ('19')
insert into t_dd values ('20')
insert into t_dd values ('21')
insert into t_dd values ('22')
insert into t_dd values ('23')
insert into t_dd values ('24')
insert into t_dd values ('25')
insert into t_dd values ('26')
insert into t_dd values ('27')
insert into t_dd values ('28')
insert into t_dd values ('29')
insert into t_dd values ('30')
insert into t_dd values ('31')
 
 select   sum(live_cnt),
             sum(sat_cnt),
             sum(sun_cnt ) 
   from  ( 
              select yyyy+'/'+mm+'/'+dd  tday , 1 live_cnt , 
              ( case when  DATEPART ( dw ,  yyyy+'/'+mm+'/'+dd    ) = 7 then 1 else 0 end ) sat_cnt,
              ( case when  DATEPART ( dw ,  yyyy+'/'+mm+'/'+dd    ) = 1 then 1 else 0 end ) sun_cnt
                 from t_yy, t_mm , t_dd
              where ISDATE (yyyy+'/'+mm+'/'+dd) = 1
                  and t_yy.yyyy between '1978' and '2007' 
              ) res
where res.tday between '1978/01/25' and '2007/06/02'