count over partition by

select 

알파

,날짜

,count(1)over(partition by 날짜)"알파별 날짜별 소계"

,count(1)over(partition by 알파)"알파별 소계"

,count(1)over()"총계" 

from 테이블이름;